Can't save in Hidden Worksheet after converting to Excel Add-In

[Graff]

I have an issue i hope someone can help me with.
I have an Add-In that i created in VB to create a report from RAW data that
i download every day. I would like the Add-In to save certain totals after
running the report so i can use them next time i run new report, just to
compare new and old numbers.
Everything works fine, if i run the code in a regular Excel file, but once i
convert it to Add-In, it doesn't save the data.
Is there a way to save anything in an Add-Inn or does it only retain data
that you work with at the moment?
I'd appreciate any feedback on this. It would save me a lot of manual work
if it would be possible.

Thanks,
Igor

 

[Chip Pearson]

An XLA Add-In is really any different that a regular XLS workbook,
except that the IsAddIn property is True. You can store data in an XLA
but be sure to call ThisWorkbook.Save. XLA's don't prompt you to save
if a change has been made.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Chip Pearson]

An XLA Add-In is really any different that a regular XLS workbook, should be
An XLA Add-In is *NOT* really any different that a regular XLS workbook,

Sorry for any confusion.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Graff]

Chip,

Thanks for your help. Everything works perfect now.

Regards,
Igor