@googlegroups.com
Sent: Thu, November 12, 2009 1:40:43 PM
Subject: Re: $$Excel-Macros$$ Re: Store Cell formatting
Hi Paul
Thank you for the suggestion. Whenever I have to format a sheet which requires
complex formatting, I will always keep a hidden sheet which is already
formatted.
I will copy
for the sheet, then only process the
differences.
Paul
--
*From:* Hemant Hegde hemantbales...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wed, November 11, 2009 10:55:41 AM
*Subject:* $$Excel-Macros$$ Re: Store Cell formatting
Hi
Thank you Paul
Hi
Thank you Paul and RolfJ
The file I want to save in binary format already contains 4 ararys of
variable size (these are to store: the file version info, settings and user
preferences, main data, and other data)
The excel formatting I and values I am trying to save is just a part of the
above
restore the document,
you first set the defaults for the sheet, then only process the differences.
Paul
From: Hemant Hegde hemantbales...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, November 11, 2009 10:55:41 AM
Subject: $$Excel-Macros$$ Re: Store Cell
Hemant,
I was hoping someone would come up with an answer for you!
I have an application that stores the entire workbook as data in
Oracle tables.
the actual document is retrieved and re-assembled.
If changes are made, the Oracle database is updated.
Now, users sometimes want to make cells
Please explain why you don't save the worksheet resulting from your
calculations in the intrinsic Excel format (i.e. as an Excel
workbook).
On Nov 8, 12:20 pm, Hemant Hegde hemantbales...@gmail.com wrote:
Hi
After a lot of coding and lengthy calculations (takes up to 2 minutes) I get
a sheet