Check if the file exists using VBA

by

Note your code contains Dir("thesentence") which should be Dir(thesentence).

Change your code to this

Sub test()

thesentence = InputBox("Type the filename with full extension", "Raw Data File")

Range("A1").Value = thesentence

If Dir(thesentence) <> "" Then
    MsgBox "File exists."
Else
    MsgBox "File doesn't exist."
End If

End Sub

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. Function to convert column number to letter?
  3. Better way to find last used row
  4. How to insert a picture into Excel at a specified cell position with VBA
  5. 2 Dimensional array from range [closed]
  6. filter out multiple criteria using excel vba
  7. How can I create a calendar input in VBA Excel?
  8. Quicker way to get all unique values of a column in VBA?
  9. How to set recurring schedule for xlsm file using Windows Task Scheduler
  10. Change date format using substitute or replace
  11. VBA: Convert Text to Number
  12. Concatenate cell data into another data if values matches
  13. Iterating through populated rows
  14. Using VBA to detect which decimal sign the computer is using
  15. Referencing Excel Userform Control Name Value From String (VBA)
  16. Loop through each row of a range in Excel
  17. Fill formula down till last row in column
  18. Outputting Excel rows to a series of text files
  19. How to create a range from two ranges in VBA?
  20. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  21. If string contains word from list, return value adjacent to list value
  22. Refreshing all the pivot tables in my excel workbook with a macro
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. excel vba freeze pane without select
  26. Converting a string representation of a constant into a constant?
  27. Macro to export MS Word tables to Excel sheets
  28. VBA WinHTTP to download file from password proteced https website
  29. Access files with long paths (over 260)
  30. How to highlight selected text within excel

Leave a Comment