My company does a lot of work in Microsoft Office templates in Word and
Excel. Subversion handles these as binary files and that is okay with
me but there are also the VBA project elements (VBA source code in
modules and classes as well as binary forms). I would like to utilize
Tortoise as our client for Subversion access and somehow manage to track
the internal VBA project elements as well as the files as a whole.
So far, I've written Microsoft Office AddIns to export the source code
and binary form blobs to files and placed them in a subdirectory
underneath where the template files reside. This gets me about 40% of
what I need J It allows for all changes to the source code and form
elements to be in the repository tracked separately from the binary of
the entire document (so I can see a history of a source code module
etc.)
To get to 100%, I need to be able to convey to knowledge workers that
the file they are working on in Office is in revision control and give
them some sort of notification if they need to update their copy prior
to working on it etc. Most of our content workers only work in the
document/spreadsheet, and not in the VBA side of things but we need to
all be utilizing the same revision control mechanism to keep from
someone getting out of sync or walking over someone elses changes.
Received on 2008-01-24 18:40:28 CET