PDA

View Full Version : Detect changes to VBA code.



myredroom
08-06-2010, 02:24 AM
Excel VBA (2000 and above)
Is there a way of testing (in Workbook_BeforeClose for example) if there have been any changes to the VBA code this session. I know how to detect for changes (ActiveWorkbook.Saved), but I want to be able to know if the code has changed, so I can automate my change log.

Thanks in advance.

Bob Phillips
08-06-2010, 04:19 AM
Don't think so. You could protect the code so that they can't change it, unless they hack it.

myredroom
08-06-2010, 06:04 AM
The code is well and truly protected - I just want to automate tracking my own changes to the code.

I'll come up with another solution instead.

myredroom
08-08-2010, 11:04 AM
Anyone else with any ideas?

Bob Phillips
08-08-2010, 11:47 AM
The code is well and truly protected - I just want to automate tracking my own changes to the code.

I'll come up with another solution instead.

Then use a code management solution.

myredroom
08-08-2010, 02:05 PM
Then use a code management solution.



Such as?

Bob Phillips
08-08-2010, 03:25 PM
Such as Subversion.