Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Datestamping a file created by a macro
I have a great macro that puts a worksheet from an open workbook, does
some editing and saves with a specific file name. And, I found this code he Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("yourworksheet").Range("desiredrange") = Now End Sub to change a cell value from NOW() to the date it was saved. Now, the problem. The above code belongs in the ThisWorkbook part of the book's code, and I don't know where to put that in the macro that creates the workbook to put it in that part of the new workbook. Thanks to all. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Datestamping a file created by a macro
I'm stupid. Here is the code that makes the worksheet. I guess I just
need to know where to put the code above into this so that it ends up in the ThisWorkbook part. ..SaveAs Filename:="C:\Manifest\Manifest Archive\" & Worksheets("MANIFEST").Range("C12").Value & " " & Worksheets("MANIFEST").Range("C13").Value & " " & Worksheets("MANIFEST").Range("G14").Value & " " & Worksheets("MANIFEST").Range("D10").Value & " " & Format(Now, "mm-dd-yyyy hh-mm-ss") .Close savechanges:=False 'if you're done with it. ActiveWorkbook.Saved = True ActiveWorkbook.Close Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Datestamping a file created by a macro
Disregard. This has been solved. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
I moved a file from work to home and now my color macro does not w | Excel Worksheet Functions | |||
Open an Excel file with a date as today in a macro | Excel Discussion (Misc queries) | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
File asks to update when no links were created | Links and Linking in Excel |