View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vrzimmerm@hotmail.com is offline
external usenet poster
 
Posts: 28
Default Macro to save file in changing directories?

I am trying to write a macro that will save the current spreadsheet in
a unique directory depending on an input supplied by the user. In
this case the user will input a month number. If they input "1" the
macro will save the file in a directory named "Jan". If "2" is
inputted it will save the file to "Feb" etc. What would the VBA
coding for this look like?

Would it be easier if I have the user just input "Jan"....then use
this info in the path for the save command?

Many thanks!