Worksheets in an excel add-in

O

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
 
B

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)
 
O

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
 
J

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
 
Top