Still learning. I'm trying to create a Macro that several different people will use on different computers. The problem is if I use the "Save As" then it saves the files to my user. This causes the macro not to work on anyone's computer other than mine. What am i doing wrong?
Please Login or Register to view this content.
You are specifying a static location in the 'Filename:=' argument. Would you mind asking the user where they would like it saved via dialog?
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
if you want to just save to the desktop then you can get that path with:
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
AlvaroSiza
I would prefer to have the user choose a location. I just don't know how to do that.
I would prefer to have the user choose a location. I just don't know how to do that.
HTH
Regards, Jeff
Please Login or Register to view this content.
This gets the path name but when it goes to actually save the file I get this error message.
"EAR_UPS_Import.csv' cannot be accessed. The file may be corrupted, located on a server that is not responding or read-only."
What am I doing wrong?
So this is finally what worked. Thanks for your help I could have figured it out otherwise.
Please Login or Register to view this content.
Thank you for your help. This is perfect. More than what I was looking for.
oh yeah - my bad. glad you figured out the right syntax!
I finally got my solution
Please 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