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
<(E-Mail Removed)> 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 <(E-Mail Removed)>
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
><(E-Mail Removed)> 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 <(E-Mail Removed)>
> 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
> ><(E-Mail Removed)> 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
>