Date issue with macro

Originally Posted by pb71

Try something like this in your code above ...

dailytaskpath = Range("F3").Value
dailytaskfile = Format(Date, "ddmmyyyy") & "_" & Format(Time, "hhmmss")
Range("G3").Value = dailytaskfile

Hello

Thank you for your code. Whilst this may save the file with the date and time of saving, when I re-open the file (say on another day), the date within the file will still have changed to the current day.

Ok say for example the command 'NOW()' resides in cell A1 on my spreadsheet, although that command will always display the current date, what I need is a piece of code which once the document has been saved, the date displayed by the 'NOW()' command will remain the same (i.e. disabling the 'NOW()' command). So something like:

Upon saving the spreadsheet, then the date displayed in cell A1 remains as it is (therefore disabling the 'NOW()' command.

Is there such a code?

Sorry if I have confused the issue with my explanation.

Ivor