Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VB: Open/Save *.xls
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save all open excel files? | Excel Discussion (Misc queries) | |||
how to save an Excel 2007 on CD, be able to open it using 2005 | Excel Discussion (Misc queries) | |||
browse to open and save as in Excel vbs | Excel Discussion (Misc queries) | |||
excel prob - cant save worksheet if someone has it open in a veiwe | Excel Discussion (Misc queries) | |||
How do i save all open files in excel at once? | Excel Discussion (Misc queries) |