Thread: SaveAs Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Little Greg Little is offline
external usenet poster
 
Posts: 10
Default 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