| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Selects Directory to Save File Based on Sheet Criteria
I am trying to set up a macro that looks in the contents of a cell, for
example E9, and determines the file path and file name to save the file. E9 will contain a date. Based on the date, the macro will need to select the correct folder: Cell E9 = 8/9/07 File path & name = C:\2007\(08) August\MCBS 08-09-2007.xls Any suggestions? I appreciate it. Adam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAVE & SEND A FILE BASED ON TEXT IN A CELL VIA MACRO | New Users to Excel | |||
| Save new file in same directory | Excel Programming | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
Threaded Mode
