View Single Post
  #1   Report Post  
Tim C
 
Posts: n/a
Default Dialogue Box - how do I get and save as file name entered?

I save a copy of an updated excel file each day to the same directory. I
want to create a macro that prompts for the daily file name and saves it to a
predetermined file location. THanks.
--
Tim C