| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Save As through VBA
I have a command button in my excel file after clicking on which it
does some calculations. I need a small piece of code at the end of my code which will save a copy of that file (Save As) in C:\ with the current date and time (eg. xxx06271315.xls) 0627 is the date 27th June and 1315 is the time 1:15 PM Can anybody help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Save As through VBA
Try
ThisWorkbook.SaveAs Filename:= _ "C:\" & Format(Now, "mmddhhmm") & ".xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... I have a command button in my excel file after clicking on which it does some calculations. I need a small piece of code at the end of my code which will save a copy of that file (Save As) in C:\ with the current date and time (eg. xxx06271315.xls) 0627 is the date 27th June and 1315 is the time 1:15 PM Can anybody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
| Excel marcos firing on file save as but not file save | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
Hybrid Mode
