Cannot save to desktop

bikeordie1

New Member
Joined
Jun 28, 2012
Messages
46
at the end of my code is:
activeworkbook.saveas "C:\users\" & environ("Username") & "\Desktop\GRN Report - " & format(date, "MM-DD-YYYY")

Now this works fine for myself and a few other users in the office (all the same platforms - win7)

except for 2 users which get this error:

run time error '1004':
Microsoft excel cannot access the file:
'C:\Users\john.doe\Desktop\0AB3D100'. There are several possible reasons:
the file name or path does not exsit
the file is in use
workbook you are trying to save has the same name

the part in red is different every time the error comes up. like a temp file or something. I cannot for the life of me find the issue here. Any thoughts?
 
I would try taking out different parts of the path or modifying the path till you get it to work or behave differently. If you can find exactly what part of the path or which character is causing the trouble, that will give more clues that may help.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top