Re: $$Excel-Macros$$ control the macro commands in excel vba

2016-02-26 Thread Paul Schreiner
OK... I think we need to clarify some things.The VBA project doesn't have a different datelastmodified than the excel Workbook.And the datelastmodified doesn't get changed until you SAVE the workbook. So...In your scenario.Do you have two files? a "Master" file and a "user" file and you wish to

$$Excel-Macros$$ control the macro commands in excel vba

2016-02-25 Thread Kat
Hi guys, I have 7 subs in my module. I would like to control that if the datelastmodified of excel vba is same as datelastmodified of the master file, then don't run the 7 subs. If the datelastmodified of both are not same, then run all the subs. What should I put in 'ThisWorkbook' and how do