Hi
I have ran the following module via Excel 2007 on window XP platform, i have no issue on it. But when i run on Window 7 by using Excel 2007, a debug message pop out in BOLD as follow. I have changed the dir path, it does not work.
Please Login or Register to view this content.
Please help. Highly appreciated. Many thanks
Vickie
Last edited by wongwlv; 02-16-2012 at 04:06 AM.
Which line is supposed to be bold?
Good luck.
Originally Posted by OnErrorGoto0
ThanksPlease Login or Register to view this content.
On Windows 7, that path will not exist. Also, you shouldn't use ChDir without using ChDrive first, since if your current directory is not on the same drive, ChDir won't work.
Rory, many thans for the spot. However, I need to run the same module on window xp and window 7 (under Excel 2007), how should i change to make both work? Any advices? Thanks
Use
To get the path to my documents, then append any additional folder paths to that.Please Login or Register to view this content.
THANK YOU... RORY.. Sorry it takes so long for me work on it on because i fall sick. Will try again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks