Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving with VBA
Will the text always be the same
Workbooks("Report.xls").SaveAs "S:\Reports\Report" & _ format(data,"yyyymmdd") & ".xls" -- Regards, Tom Ogilvy "havocdragon" wrote in message ... Hello all =). I am programming a macro in VBA at work, and I've come across one major hicup. The macro I have is assigned to a button on a worksheet, this macro then opens a report, sorts, formats, and references information, and then saves it to the network drive (so far no problems). The only problem I am having, is I wan't this file to save with text+current date everytime I run the macro. The problem I'm having with that, is no matter what I do, once the first entry has been made to the save as, it always is that. Any thoughts on how I could do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving with VBA
Dude thanks!!! I have been banging my head on that for a while. I knew it had
to be something similar to that, but for some reason I just couldn't get the syntax right =) "Tom Ogilvy" wrote: Will the text always be the same Workbooks("Report.xls").SaveAs "S:\Reports\Report" & _ format(data,"yyyymmdd") & ".xls" -- Regards, Tom Ogilvy "havocdragon" wrote in message ... Hello all =). I am programming a macro in VBA at work, and I've come across one major hicup. The macro I have is assigned to a button on a worksheet, this macro then opens a report, sorts, formats, and references information, and then saves it to the network drive (so far no problems). The only problem I am having, is I wan't this file to save with text+current date everytime I run the macro. The problem I'm having with that, is no matter what I do, once the first entry has been made to the save as, it always is that. Any thoughts on how I could do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
Saving | Excel Discussion (Misc queries) | |||
Saving help | Excel Discussion (Misc queries) | |||
Saving on CD | Excel Discussion (Misc queries) | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |