Importing VBA file into Excel

B

Brian Service

We have an Excel spreadsheet that has several VBA classes and bas modules
included in it. This XLS file is checked into a source control system and
contains the spreadsheet and all the VBA code in 1 binary file.

We have a build process that runs automatically and launches the spreadsheet
and does several things.
If the VBA code is not stored with the file, then it won't run correctly.

The source control system will not merge binary files, hence, only 1
developer can modify the file at a time. We would like to have several
developers working on the VBA code at the same time and check in source
(text) code files (.cls and .bas) into source control. We would then like
the build process to import the VBA code into the XLS file when launching
it. Is this possible? Or, must it be a manual step for the developers to
use the "Import File..." function to import into XLS and then check the XLS
file back into source control?

Thanks, Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
MS Project Import Error Row 1 Column 5 2
Error outlook.com 0xc0000005 trying to open custom controls 0
Adding data to MS Access from csv file 0
Automated Build -- auto import of .BAS module into XLS or XLT? 2
Linking data in MS Word into Excel 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Use external file variable in formula 2

Top