Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 863
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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!



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creative Ways to use Versioning or Tracking in Excel atlcharm Excel Discussion (Misc queries) 0 March 3rd 08 06:17 AM
Versioning in Excel Dave M Excel Discussion (Misc queries) 0 January 17th 06 04:31 PM
How do I avoid saving multiple Excel/Wordfiles for versioning purp Neil Excel Discussion (Misc queries) 1 December 13th 04 12:57 PM
How do I avoid saving multiple data files for versioning purposes. [email protected] Excel Discussion (Misc queries) 1 December 13th 04 12:57 PM
Versioning Question ExcelMan Excel Programming 9 September 21st 03 11:48 PM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"