Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Automatically Save As
I am working on a macro to do a series of operations: Assign a Workorder
#;Date; Give job an active status, etc. I've got most of the bits and pieces but I would like the macro finalize the operation by automatically "Save as", assign a name using custom identifiers, break the link, reset the page. I've recorded a macro performing the Save As but I need to know how assemble the parts from my work oder and insert them into the title Workorder#LastnameDescriptionDate =(H5) &(B11) &(I2) &(I8) Any advice would be great, Thanks BILL T. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Automatically Save As
Dim strFile As String
Dim strFolder As String strFolder = "c:\" strFile = Range("H5") & Range("B11") & Range("I2") & Format(I8,"dd-mm-yy") ActiveWorkbook.SaveAs Filename:=strFolder & strFile ActiveWorkbook.Close If this post helps click Yes --------------- Jacob Skaria "fail2excel" wrote: I am working on a macro to do a series of operations: Assign a Workorder #;Date; Give job an active status, etc. I've got most of the bits and pieces but I would like the macro finalize the operation by automatically "Save as", assign a name using custom identifiers, break the link, reset the page. I've recorded a macro performing the Save As but I need to know how assemble the parts from my work oder and insert them into the title Workorder#LastnameDescriptionDate =(H5) &(B11) &(I2) &(I8) Any advice would be great, Thanks BILL T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to automatically save document with cell reference as filena | Excel Discussion (Misc queries) | |||
Macro to automatically print & save as PDF | Excel Discussion (Misc queries) | |||
save automatically | Excel Discussion (Misc queries) | |||
Automatically Save | Excel Programming | |||
Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) |