I hate paths!

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

Could someone please tell me how to indicate current path in VBA when using
Excel? When I record a macro usinly excel, for example in haveing anothe
workbook open, it always includes the full path. What I want is for the
Workbook to be opened in the current directory, so I can move this directory
to other computers and have it the macro work without having to change paths
at each new machine. I tried ./, but that didn't work for me.
Ross
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Macro to open Workbook in default path. 2
Relative Path in Connection String 2
Need help using a relative path in VBA 0
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
How do I hyperlink to a cell in existing workbook? 4
Run a macro from another workbook in the QAT 1
Workbooks.Open with out full path help needed. 5

Back
Top