Will the file path always be the same folder or do you mean that you have to
search for a particular file in an unknown folder on a drive?
If always in the same path then just record the macro to open the file. The
code should be something like this.
Workbooks.Open Filename:="K:\MyPath\My File To Open.xls"
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.
