Moving Excel Macro Problems
I have created an Excel Macro that opens two other excel files combines
the data and then formats it for easy reading. On my computer it works fine but when I move it to other computers it never works properly. The most common problem is it says it can't find the files to open. But the path and file it says it can't find, exsists where it should be. Currently my code changes to the current directory and then opens the file. Would it be better to just include the entire path in the Workbooks.open Filename = _"filename" command line? |
Moving Excel Macro Problems
Yes, use the full path.
RBS wrote in message ups.com... I have created an Excel Macro that opens two other excel files combines the data and then formats it for easy reading. On my computer it works fine but when I move it to other computers it never works properly. The most common problem is it says it can't find the files to open. But the path and file it says it can't find, exsists where it should be. Currently my code changes to the current directory and then opens the file. Would it be better to just include the entire path in the Workbooks.open Filename = _"filename" command line? |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com