View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Save file to Network Drive and prompt for name

KO,

Maybe you could incorporate the current time into the filename to make it
unique?

Rob


"turtle" wrote in message
om...
I am having trouble writing a macro that when ran it will save my file
into a network location and prompt me for the file name. The network
path will always be the same place but the file name will change.

Any help would be great.
thanks,
KO