View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joann Adams Joann Adams is offline
external usenet poster
 
Posts: 1
Default file save as macro

I am trying to write macros to attached to a specific
files that will enable the automation of selecting the
correct folder the finished document will be saved in.

source document is in X folder, when user is ready to save
play macro to save in folder Y and prompt for file name
(to be entered by user)

any help would be appreciated