Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simplify changing directories | Excel Worksheet Functions | |||
Using macro to save xls as txt without changing originial xls file | Excel Programming | |||
Using Macro to Save xls to txt without changing file format | Excel Programming | |||
changing directories...with vba | Excel Programming | |||
changing directories | Excel Programming |