Hi,
I would like to have a date and time stamp as part of my file name whenever I click on a button to save my worksheet as a backup copy. I know how to do it with just a date, but I also would like to add a time stamp as well since the worksheet can be saved multiple times throughout the day. I would like to have a date & time stamp to save any updates as a file separate file. Is this possible and if so, how would you write the VBA code?
Thank you everyone for your help.
I would like to have a date and time stamp as part of my file name whenever I click on a button to save my worksheet as a backup copy. I know how to do it with just a date, but I also would like to add a time stamp as well since the worksheet can be saved multiple times throughout the day. I would like to have a date & time stamp to save any updates as a file separate file. Is this possible and if so, how would you write the VBA code?
Thank you everyone for your help.