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 |