Using VSS for Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LL - 15 Dec 2003 18:34 GMT

Hi List,

Our team will start to use VSS for source control in a
near future. Right now, we are still evaluatint it and
also try to know how to use it correctly.

In our developer team, we have lot of programs using VBA
from Excel to create some macros for users. Does anybody
can let me know how to use VSS to control Excel macro
source code? and how to compare the different versions? is
it possible that can show the difference line by line like
VB project?

Thank you for any help,

LL

Reply to this Message

Weston Morris - 16 Dec 2003 06:18 GMT

You can export the VBA to a separate file that can be checked into VSS.
There will not be native integration between Excel and VSS, however so that
you can check files in /out directly from Excel menus.

Weston

> Hi List,
>
[quoted text clipped - 12 lines]
>
> LL

Reply to this Message

LL - 16 Dec 2003 13:20 GMT

if i exported the VBA to a separate file, i can just check
in/out the exported file not the Excel file, right? How to
check in/out directly from Excel menus?

thank you,

LL

>-----Original Message-----
>You can export the VBA to a separate file that can be checked into VSS.
[quoted text clipped - 21 lines]
>
>.

Reply to this Message

Joe Masters - 23 Dec 2003 06:39 GMT

I think what you're asking for is the functionality added when you purchase
Office Developer Edition.

Joe

> if i exported the VBA to a separate file, i can just check
> in/out the exported file not the Excel file, right? How to
[quoted text clipped - 35 lines]
> >
> >.

Reply to this Message

Using VSS for Excel

Free Magazines