ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Versioning/tracking changes (https://www.excelbanter.com/excel-programming/306477-versioning-tracking-changes.html)

Poseur

Versioning/tracking changes
 
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!

Myrna Larson

Versioning/tracking changes
 
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.



Tim[_39_]

Versioning/tracking changes
 
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!




Keith Willshaw[_2_]

Versioning/tracking changes
 

"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




All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com