Re: $$Excel-Macros$$ Re: Store Cell formatting

2009-11-13 Thread Paul Schreiner
@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

Re: $$Excel-Macros$$ Re: Store Cell formatting

2009-11-12 Thread Hemant Hegde
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

$$Excel-Macros$$ Re: Store Cell formatting

2009-11-11 Thread Hemant Hegde
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

$$Excel-Macros$$ Re: Store Cell formatting

2009-11-11 Thread Paul Schreiner
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

$$Excel-Macros$$ Re: Store Cell formatting

2009-11-10 Thread Paul
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

$$Excel-Macros$$ Re: Store Cell formatting

2009-11-09 Thread RolfJ
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