I am using a version control system (SVN) to separately control my
template spreadsheet and my VBA .bas source code. I rarely change the
xls, but make many changes to the bas including client specific
branches. I need to track the code changes.

Right now, I have to manually build the solution by importing the BAS
into the XLS and resave it as an XLT.

Does anyone know how to automate the bas import?

I found a reference to how to do it in Word
(.VBProject.VBComponents.Import) but there does not seem to be an
equivalent in Excel.

Thanks in advance.

-Greg

Take a look at the following:

http://puremis.net/excel/code/004.shtml



<(E-Mail Removed)> wrote in message
news:dfa9972e-b806-4d09-868c-(E-Mail Removed)...
> I am using a version control system (SVN) to separately control my
> template spreadsheet and my VBA .bas source code. I rarely change the
> xls, but make many changes to the bas including client specific
> branches. I need to track the code changes.
>
> Right now, I have to manually build the solution by importing the BAS
> into the XLS and resave it as an XLT.
>
> Does anyone know how to automate the bas import?
>
> I found a reference to how to do it in Word
> (.VBProject.VBComponents.Import) but there does not seem to be an
> equivalent in Excel.
>
> Thanks in advance.
>
> -Greg

Thanks Mark, that worked splendidly!