PDA

View Full Version : MAcro Creation Date



paul.mac
04-17-2018, 05:02 AM
Hi,
I'm coming back to work on an Excel file I was working on last year. I was developing a macro to copy data from several worksheets to a single worksheet. I have a long list of macros which were for different bits of the code and can't remember which was the last one I worked on. Do macros have properties, which includes the creation date/time and/or modification date/time so I can find out which was the latest version?

Thanks

Paul

Paul_Hossler
04-17-2018, 07:20 AM
Closest thing would probably be the Modification Date of the XLSM itself -- which I doubt will be of any use if the macro versions are within a single XLSM