Posted: Tue Dec 02, 2008 5:00 pm Post subject: Date and time stamp
I have written a macro for an engineering application.
I want it to Date and time stamp the output page so later runs can be
easily distinguished from previous runs of the macro.
The user puts data in on an input page, the macro creates a table, does calculations on the table then prints output to an output page.
After the user has run the macro he copys the input and output pages renaming them, saving them as proof of his input data and the results.
The function "Now" updates the date-time stamp every time the sheet is made active. I need a function that puts the date and time of the macro run that never changes.
Thanks
What I had figured out while waiting for a reply was if I put the Excell function "NOW" somewhere on the spreadsheet (Out of view)
Then I created a string variable Time, assigned the value that was in the cell with the "NOW" funtion and had it print that value on the output sheet.
Not as elegent but no formating needed.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum