Hi
I have written a macro to make changes to a emailed workbook and need to keep track of each workbook in a library
I am opening a daily emailed workbook and wish to "saveas" a new workbook named with the same date and time of the original daily emailed workbook.
I do not want to save the new workbook with the date it was copied or saved as I need the new workbook file name to match the date and time the original workbook file was saved.
Then when I open copied workbooks I will know what date and time the workbook it was copied from.
I would very much appreciate help with this last part of my macro.
Regards
I have written a macro to make changes to a emailed workbook and need to keep track of each workbook in a library
I am opening a daily emailed workbook and wish to "saveas" a new workbook named with the same date and time of the original daily emailed workbook.
I do not want to save the new workbook with the date it was copied or saved as I need the new workbook file name to match the date and time the original workbook file was saved.
Then when I open copied workbooks I will know what date and time the workbook it was copied from.
I would very much appreciate help with this last part of my macro.
Regards