Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a monthly report using Visual Basic
Every month I save a hardcopy version of a report into a folder. I want to
run a macro to do this which amongst other things, names it after the respective month. ie in Jan the macro saves the hardcopy report as Report_Jan.xls. In February I want the macro to save it as Report_Feb.xls. etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a monthly report using Visual Basic
Try something like
ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") & ".xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ant" wrote in message ... Every month I save a hardcopy version of a report into a folder. I want to run a macro to do this which amongst other things, names it after the respective month. ie in Jan the macro saves the hardcopy report as Report_Jan.xls. In February I want the macro to save it as Report_Feb.xls. etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a monthly report using Visual Basic
So...would that save it as FEB if it is actually February? And if I save it
today for example it would save it as MAR? If so, I really need it to save to a month that I can manually select, for example, I need to save it as FEB today, not MAR (It's a month end report you see, so will always be a month behind the actual month). Can I point the name of the month to a cell that has data validation? "Chip Pearson" wrote: Try something like ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") & ".xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ant" wrote in message ... Every month I save a hardcopy version of a report into a folder. I want to run a macro to do this which amongst other things, names it after the respective month. ie in Jan the macro saves the hardcopy report as Report_Jan.xls. In February I want the macro to save it as Report_Feb.xls. etc. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a monthly report using Visual Basic
?B?QW50?= wrote
So...would that save it as FEB if it is actually February? And if I save it today for example it would save it as MAR? If so, I really need it to save to a month that I can manually select, for example, I need to save it as FEB today, not MAR (It's a month end report you see, so will always be a month behind the actual month). Can I point the name of the month to a cell that has data validation? If you have a date that reflects that month somewhere in the report you can include part of that cell's value in the filename. i.e.: ActiveWorkbook.SaveAs Filename:="Report_" & Format(Range("g2"), "mmm") & ".xls" -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I don't want to run visual basic editer code after saving... | Excel Discussion (Misc queries) | |||
Linking to Visual Basic for Applications Help Files | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
Visual Basic Code Remains in "memory" | Excel Worksheet Functions |