Workbooks.Open Method in VBA

by

Filename is relative to the current Excel directory (which is different from the directory in which an opened document is).

You change the current directory by using ChDir "x:\new\path".

But what you actually want to do is:

Workbooks.Open Filename:=EnsureSlash(ThisWorkbook.Path) & "myTest.xls", ReadOnly:=True

, where EnsureSlash is your custom function that appends a backslash (\) to the end of the string, if it’s not already there (because ThisWorkbook.Path ends with a slash when the path is the root directory, and doesn’t otherwise).

More Related Contents:

  1. Getting error Procedure too large in VBA Macros (Excel)
  2. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  3. Consolidating worksheets into one
  4. Loop through files in a folder using VBA?
  5. How to error handle 1004 Error with WorksheetFunction.VLookup?
  6. How can Excel VBA open file using default application
  7. How to compare two entire rows in a sheet
  8. Run same excel macro on multiple excel files
  9. how to detect whether VBA excel found something?
  10. VBA : save a file with UTF-8 without BOM
  11. Excel tab sheet names vs. Visual Basic sheet names
  12. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  13. Determine if cell contains data validation
  14. VBA – Range to jpg picture
  15. Fastest way to delete rows which cannot be grabbed with SpecialCells
  16. Combine multiple Excel workbooks into a single workbook
  17. Excel Macro, inserting internationally valid formula during run-time
  18. Sheet protection: UserInterFaceOnly gone
  19. VBScript – How to make program wait until process has finished?
  20. How to break long string to multiple lines
  21. How to copy a chart from Excel to PowerPoint?
  22. vba paste not working
  23. mac excel vba loop : from list & then export as pdf
  24. Can Advanced Filter criteria be in the VBA rather than a range?
  25. In Excel VBA, what is the way to check if the web page is fully loaded?
  26. Excel Useform: How to hide application but have icon in the taskbar
  27. Reading Web Pages using Excel VBA
  28. Excel VBA: auto click and open file from website
  29. How do I get a list of unique values from a range in Excel VBA?
  30. Query my excel worksheet with VBA

Leave a Comment