CODEWITHSUNDEEP
excelversion-controltfsvba
Rickson
Rickson

Reputation: 1090

Excel 2013: Macro Version Control Strategy

We are using TFS as source control system and I would like to implement the following:

We have Excel files on multiple workstations (all connected to TFS) that shall always use the latest version of a macro.

Therefore, I thought about somehow defining the macro in an external file which is under source control and can be centrally maintained and mapped to the local workspace of the workstations where the Excel files are located.

Within the VBA section of the Excel files, there should only be a link to that file so that always the latest version of the macro is used (assuming that the user made a GetLatest operation on the external file containing the macro).

Is a scenario like this technically possible? If yes, how can I define that the Excel file has to import the macro from the external file?

Upvotes: 1

Views: 484

Answers (1)

snb
snb

Reputation: 343

If I understand you correctly referring to the macro containing file as an Addin should do the job.

Upvotes: 1

Related Questions