View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Set Path for GetSaveAsFilename

See example 6

http://www.rondebruin.nl/copy3.htm#select

I use ChDirNet there


--
Regards Ron De Bruin
http://www.rondebruin.nl



"JR_06062005" wrote in message ...
Is there a way to set the path for Application.GetSaveAsFilename. The
dialogue opens at "My Documents". I would like for it to open at a folder on
a server (not designated as a drive since different users may have the
address mapped differently)