How do I open a file if I only know part of the file name?

by

filename*esy is already a “shell ready” wildcard & if thats alway the case you can simply;

const SOME_PATH as string = "c:\rootdir\"
...
Dim file As String
file = Dir$(SOME_PATH & "filename*esy" & ".*")

If (Len(file) > 0) Then
  MsgBox "found " & file
End If

Just call (or loop until empty) file = Dir$() to get the next match.

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. How can Excel VBA open file using default application
  4. How to compare two entire rows in a sheet
  5. Run same excel macro on multiple excel files
  6. how to detect whether VBA excel found something?
  7. VBA : save a file with UTF-8 without BOM
  8. Excel tab sheet names vs. Visual Basic sheet names
  9. Saving a Excel File into .txt format without quotes
  10. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  11. VBA – Range to jpg picture
  12. Fastest way to delete rows which cannot be grabbed with SpecialCells
  13. Combine multiple Excel workbooks into a single workbook
  14. Excel Macro, inserting internationally valid formula during run-time
  15. Sheet protection: UserInterFaceOnly gone
  16. VBScript – How to make program wait until process has finished?
  17. Making VBA Form TextBox accept Numbers only (including +, – and .)
  18. VBA Convert date to week number
  19. Inserting an Online Picture to Excel with VBA
  20. Change length of For loop while in the loop
  21. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  22. Consolidating worksheets into one
  23. Copy filtered data to another sheet using VBA
  24. Range.Find on a Date That is a Formula
  25. Range() vs Cells() vs Range.Cells()
  26. How to get address of cell which calls a VBA Functions in a Excel sheet
  27. Add new row to excel Table (VBA)
  28. In Excel VBA, what is the way to check if the web page is fully loaded?
  29. Excel VBA: auto click and open file from website
  30. VBA inheritance, analog of super

Leave a Comment