Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs Question
I'm using
Activeworkbook.SaveAs.("C:Copyofthecurrent") to save a copy on my desktop. If this runs on Win 98, works just fine. What happens if it runs on Win 2k or XP, which have multiple users? Is the user an issue or will it just save to the desktop, which is the desired result? Also, what happens in the rare case that the user doesn't have a C drive? I'd expect a macro error- How do I get around these problems, if problems they are? TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 question involving SaveAs to .XLS | Excel Discussion (Misc queries) | |||
Saveas VBA question | Excel Discussion (Misc queries) | |||
More help with SaveAs | Excel Programming | |||
Question Using SaveAs Method | Excel Programming | |||
SaveAs,csv | Excel Programming |