Addins - Is it necessary to duplicate changes in both the VBAProject AND the Addin

[Jeff Stryer]

I create a VBAProject called test.xls
I compile an addin now called test.xla

I have 1 function and 1 subroutine in text.xls that work fine.

That function and subroutine are also duplicated in the module of
test.xla

I load the addin into a second file test2.xls

The function and the subroutine work fine in test2.xls

However, I notice that any changes I make to the addin have to be
replicated
in test.xls

It seems that, in order for the addin to work there must be identical
copies of the code in both the worksheet and its associated addin
file.

What am I missing? I don't think this is correct and want to know the
proper way of maintaining addin code.

Any help greatly appreciated

Jeff Stryer

 

[Bob Phillips]

Jeff,

I used to do it this way. I don't bother anymore.

All I do is load the add-in, test it and make any changes to the code, and
then save the add-in project from the VBE.

You can always change the IsAddin property of the add-in to false, and that
will make the underlying workbook visible, and then you can save that as an
xls file if you want.

Just don't forget to save version copies, to allow regressing back if
necessary.

--

HTH

RP
(remove nothere from the email address if mailing direct)