alcorjr
Active Member
- Joined
- Dec 29, 2002
- Messages
- 416
hi guys, I got this command:
The problem, is that for some reason, the book gets saved "all over the place", as it were.
That is, I have to look for it in different folders instead of getting saved over the current one, which is in "My desktop"
How can I make it save it always in My desktop, in spite of some users being in a network environment, and others not?
Thanks a bunch
Code:
ActiveWorkbook.SaveAs Filename:= _
"HORSES_TO_DATE.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
The problem, is that for some reason, the book gets saved "all over the place", as it were.
That is, I have to look for it in different folders instead of getting saved over the current one, which is in "My desktop"
How can I make it save it always in My desktop, in spite of some users being in a network environment, and others not?
Thanks a bunch