| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL Save As
Hi,
I've got a macro that runs a whole set of stuff and I would like to add a final tweak so that the file saves itself with a unique date stamp. This is run off a button click within a file. The format will be: SaveAs \\network_path\yymmdd My charts.xls Can anyone please tell me the syntax to make XL save as a different file name, please? (As you can see, I'm not a programmer - learning this stuff as I go along) TIA Dave |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XL Save As
Try this
Sub AATest() mypath = "J:\Mydir\" 'Change to full path name ThisWorkbook.SaveAs mypath & "Chart_" & Format(Date, "yyyy_mm_dd") End Sub Mike "Risky Dave" wrote: Hi, I've got a macro that runs a whole set of stuff and I would like to add a final tweak so that the file saves itself with a unique date stamp. This is run off a button click within a file. The format will be: SaveAs \\network_path\yymmdd My charts.xls Can anyone please tell me the syntax to make XL save as a different file name, please? (As you can see, I'm not a programmer - learning this stuff as I go along) TIA Dave |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XL Save As
Perfect!
My thanks "Mike H" wrote: Try this Sub AATest() mypath = "J:\Mydir\" 'Change to full path name ThisWorkbook.SaveAs mypath & "Chart_" & Format(Date, "yyyy_mm_dd") End Sub Mike "Risky Dave" wrote: Hi, I've got a macro that runs a whole set of stuff and I would like to add a final tweak so that the file saves itself with a unique date stamp. This is run off a button click within a file. The format will be: SaveAs \\network_path\yymmdd My charts.xls Can anyone please tell me the syntax to make XL save as a different file name, please? (As you can see, I'm not a programmer - learning this stuff as I go along) TIA Dave |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XL Save As
Your welcome and thanks for the feedback
"Risky Dave" wrote: Perfect! My thanks "Mike H" wrote: Try this Sub AATest() mypath = "J:\Mydir\" 'Change to full path name ThisWorkbook.SaveAs mypath & "Chart_" & Format(Date, "yyyy_mm_dd") End Sub Mike "Risky Dave" wrote: Hi, I've got a macro that runs a whole set of stuff and I would like to add a final tweak so that the file saves itself with a unique date stamp. This is run off a button click within a file. The format will be: SaveAs \\network_path\yymmdd My charts.xls Can anyone please tell me the syntax to make XL save as a different file name, please? (As you can see, I'm not a programmer - learning this stuff as I go along) TIA Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| Disable save, save as, but allow save via command button | Excel Programming | |||
| How to diasble save and save as menu but allow a save button | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Linear Mode
