Hey!
Ive made macro which open new workbook and then save it to your computer. It works well using my computer. Then I sent it to my friend that he could use it. When he runs the macro this error comes up " Microsoft excel cannot access the file C:\... The file name or path doesnt exist, the file is being used by another program.. " etc..
Could someone help me with this error?
Br. Antti
need to see the code to fix it ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Here is the critical part of code
Please Login or Register to view this content.
what's the point of opening and closing and then deleting the workbook? it appears you could simply use
though perhaps the user does not have permission to write to the root of CPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks