Cannot save to desktop

[bikeordie1]

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?

 

[bikeordie1]

and thank you all for your help so far. i've been working extensively on this so its rather important

 

[chuckchuckit]

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.

 

[bikeordie1]

Ok i'll try that in the morning, for now i have to get out of the office. I'll post here on the results. Thanks