Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Apparently a rudimentary environment like the VBE does not have
any way to track changes to modules nor can I find any plug-in or add-on to do it. Anyone have a system worked out? I'm constantly changed and tweaking my projects and I do it at home and at work so I send my files back and forth and I'm constantly getting confused about which is which version or latest good revision. BTW, the email server at work does not allow .bas extension attachments thru - so I just change them to .txt for the trip. -- I'm gonna let you go now. Poseur Be whoever you want to be...it's the 'net! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I export the module as a BAS (text) file. Then I use WinDiff, a file compare
utility, to compare the versions. If you don't have WinDiff, you could use Word for this purpose. On Tue, 10 Aug 2004 03:37:07 -0000, Poseur wrote: Apparently a rudimentary environment like the VBE does not have any way to track changes to modules nor can I find any plug-in or add-on to do it. Anyone have a system worked out? I'm constantly changed and tweaking my projects and I do it at home and at work so I send my files back and forth and I'm constantly getting confused about which is which version or latest good revision. BTW, the email server at work does not allow .bas extension attachments thru - so I just change them to .txt for the trip. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
why not simply put comments into your code, eg: -
' Version 2.1 Saved 15/08/04 10:04 or at each area you've changed (as long as there aren't too many!) alternatively, i presume this is connected to a workbook, so you could have a before_close macro to save the current date/time (and even incremental version number) to cells in a sheet tim "Poseur" wrote in message ... Apparently a rudimentary environment like the VBE does not have any way to track changes to modules nor can I find any plug-in or add-on to do it. Anyone have a system worked out? I'm constantly changed and tweaking my projects and I do it at home and at work so I send my files back and forth and I'm constantly getting confused about which is which version or latest good revision. BTW, the email server at work does not allow .bas extension attachments thru - so I just change them to .txt for the trip. -- I'm gonna let you go now. Poseur Be whoever you want to be...it's the 'net! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Poseur" wrote in message ... Apparently a rudimentary environment like the VBE does not have any way to track changes to modules nor can I find any plug-in or add-on to do it. Anyone have a system worked out? I'm constantly changed and tweaking my projects and I do it at home and at work so I send my files back and forth and I'm constantly getting confused about which is which version or latest good revision. I use Rob Boveys code cleaner to export the forms and modules and store them in a code management system http://www.appspro.com/Utilities/Utilities.htm We have historically used source safe but are switching to CVS/WinCVS This is freeware http://www.cvsnt.com/cvspro/ Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creative Ways to use Versioning or Tracking in Excel | Excel Discussion (Misc queries) | |||
Versioning in Excel | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) | |||
Versioning Question | Excel Programming |