| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't save in Hidden Worksheet after converting to Excel Add-In
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't save in Hidden Worksheet after converting to Excel Add-In
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't save in Hidden Worksheet after converting to Excel Add-In
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't save in Hidden Worksheet after converting to Excel Add-I
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
| What is the best way in excel 2007 to save hidden large data objec | Excel Programming | |||
| How can I save Excel subtotals without saving hidden (Level 3) r | Excel Worksheet Functions | |||
| Excel to save as a hidden file? | Excel Programming | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
Linear Mode
