| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a macro to save to a specific drive in Excel?
I wrote a macro in excel to facilitate creating monthly reports. I want it
to save to a new folder each month (ie. the current monthly folder), but I am not sure how to write a changing "save as" formula. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use a macro to save to a specific drive in Excel?
Something along the lines of :
Thisworkbook.SaveAs "C:\RootFolder\" & Format(Date,"yyyymmm") & "\Basename.xls" might give you some ideas. -- Regards, Tom Ogilvy "Meredith" wrote in message ... I wrote a macro in excel to facilitate creating monthly reports. I want it to save to a new folder each month (ie. the current monthly folder), but I am not sure how to write a changing "save as" formula. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use a macro to save to a specific drive in Excel?
hi,
formulas return values. they cannot perform actions such save as. add this to your macro at an appropriate place. Application.Dialogs(xlDialogSaveAs).Show regards FSt1 "Meredith" wrote: I wrote a macro in excel to facilitate creating monthly reports. I want it to save to a new folder each month (ie. the current monthly folder), but I am not sure how to write a changing "save as" formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set specific default folder and/or drive to open - Excel 2007 | Excel Discussion (Misc queries) | |||
| Cant save Excel spreadsheets to S drive | Excel Discussion (Misc queries) | |||
| Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
| Macro in excel to save to an unmapped drive ! | Excel Discussion (Misc queries) | |||
| Prgrammatically save a file to a specific folder on a network drive | Excel Programming | |||
Hybrid Mode
