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

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)


On Fri, 2 Jan 2009 12:42:01 -0800, Graff
wrote:

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

On Fri, 02 Jan 2009 15:54:29 -0600, Chip Pearson
wrote:

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)

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)


On Fri, 2 Jan 2009 12:42:01 -0800, Graff
wrote:

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,

Thanks for your help. Everything works perfect now.

Regards,
Igor

"Chip Pearson" wrote:

On Fri, 02 Jan 2009 15:54:29 -0600, Chip Pearson
wrote:

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)

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)


On Fri, 2 Jan 2009 12:42:01 -0800, Graff
wrote:

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