Excel VB: Open/Save *.xls

B

Bryce K.

I have a mysterious problem. I have written VB code in
Excel that searches specified subdirectories on a network
for all *.xls files nad opens them. It will work
perfectly for several runs. However, after saving the
file and code, I close Excel and all the opened files.
When I open the same file again and run the macro, it
fails to find or open any of the files that it had
before. Any clue why it can't find the files after
closing and opening the file? I can send the code to
anyone who can help.

Thanks, Bryce
 

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

Top