Convertion from XLA to COM Addin for Excel

[alkan]

I have been converting some of my XLA files to COM Addins. I managed
to convert mostly everything, but I don't know what to do with the
worksheets I have in the XLA file. These worksheets are needed since
some VBA functions read ranges from these sheets. Is there any way of
adding these worksheets into the COM Addins?

I am using Office 2000 Developer and my target application is Excel.

Ismail

 

[Stephen Bullen]

Hi Ismail,

I have been converting some of my XLA files to COM Addins. I managed
to convert mostly everything, but I don't know what to do with the
worksheets I have in the XLA file. These worksheets are needed since
some VBA functions read ranges from these sheets. Is there any way of
adding these worksheets into the COM Addins?

I am using Office 2000 Developer and my target application is Excel.

There is a limit to what is suitable for writing as a COM addin. COM
Addins can not contain worksheets for their own referencing. If the
worksheets are just lists of data, you could add those to the COM Addin
as hard-coded lists.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk