Worksheets in an excel add-in

[On Ali]

Hi,

Is there any way of being able to maintain (edit) the Worksheets inside
an Excel Add-in without converting the add-in back to .xls?

Is there any other approach of providing managable data along with the
Add-in?

Thanks,

With regards,
On Ali

 

[Bob Phillips]

The add-in is just a workbook like any other, and you can write to the
worksheets contained therein. Just save it as you would.

But I would add that saving data in the add-in does not sound like good
design to me. IMO you should separate the business logic (the code in the
add-in) from the data, it eases maintenance.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[On Ali]

The data is like a static data which i do not want to specify inside
the macro code.

and the data is large hence i want to specify it in a sheet. but it
also has to go with the add-in

how do i modify that sheet without saving it back as .xls

 

[Jon Peltier]

In VBA, go to the Project Explorer window, and select the add-in's
ThisWorkbook. In the Properties window, change its IsAddin property to
False. The workbook appears in the Excel window. Do your editing, then go
back and change the add-in workbook's IsAddin property back to True.

- Jon

 

[On Ali]

Hi Jon

Thanks, This was something that i was looking for

Thanks again.

On Ali