Is there "SourceSafe" for Excel VB Macros?

  • Thread starter Thread starter Henry Fleming
  • Start date Start date
H

Henry Fleming

We have a source/version control system called SourceSafe that handles
storage and versioning of C++, Java, and ASP files. However, I need a
similar system for Excel Visual Basic macros. The problem is that
they seem to be embedded in the .XLS file. I don't know if the macros
can be stored as individual source code files the way the other
languages can. My macros are getting large enough that this is
becoming an issue. Can anyone help?
 
Henry,

There are 4 basic ways to store macros (maybe more)
1. Macros in a workbook - available only when the workbook is open
2. Macros in your Personal.xls - available everytime you open Excel
3. Macros in an Add-In - available everytime you open Excel and have
checked the Add-In in your Add-In list
4. Macros in any workbook stored in the same folder as your
Personal.xls - available every time you open Excel.

Note that if you create a custom toolbar button and assign it to a macro
that is in a workbook that will be closed most of the time. Clicking the
button will open the workbook and run the macro.
 
Back
Top