Using a wildcard to open an excel workbook

by

We cannot open a file using a wildcard – imagine the chaos if we could!

You’ll need to use Dir(ActiveWorkbook.Path & "\302113*.xlsm") to loop through the files that this returns. If there will only be one then just use this function once:

Dim sFound As String

sFound = Dir(ActiveWorkbook.Path & "\302113*.xlsm")    'the first one found
If sFound <> "" Then
    Workbooks.Open filename:= ActiveWorkbook.Path & "\" & sFound
End If

Dir Function :tech on the net

More Related Contents:

  1. VBA comma separated cells, needt last entry only
  2. Wait for shell command to complete [duplicate]
  3. Unique Random Numbers using VBA
  4. Populate unique values into a VBA array from Excel
  5. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  6. How to add a named sheet at the end of all Excel sheets?
  7. Find last used cell in Excel VBA
  8. VBA general way for pulling data out of SAP [closed]
  9. Does Dir() make any guarantee on the order of files returned?
  10. Call a Sub with a String
  11. Delete Row based on Search Key VBA
  12. How to add a button programmatically in VBA next to some sheet cell data?
  13. Assign keyboard shortcut to run procedure
  14. Uncheck all checkboxes across entire workbook via CommandButton
  15. return csv file as recordset
  16. VBA workbooks.Close without being prompted to if the user wants to save?
  17. Get text from clipboard using GetText – avoid error on empty clipboard
  18. Copy a selected range to another worksheet
  19. Benchmarking VBA Code
  20. Excel macro – paste only non empty cells from one sheet to another
  21. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  22. Display milliseconds in Excel
  23. Application.Quit command not closing the entire Excel Application
  24. Create hyperlink to another sheet
  25. Trying to open the workbook in separate instance
  26. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  27. Create folder path if does not exist (saving from VBA)
  28. Concatenate multiple ranges using vba
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment