Hi Paul
Thanks for the reply. I am using excel 2003.
I learnt about xll files only through google search. I dont have any Idea
how to make an xll file or how to use an existing one.
Do you know how to evaluate this?
x = " = Y(1,1).Value1"
where value1 is a property of a variable defined in a c
s.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 the default
hat way, when you restore the document,
> you first set the defaults for the sheet, then only process the
> differences.
>
> Paul
>
> --
> *From:* Hemant Hegde
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, November 11, 2009 10:55:41
rent)
that way, when you restore the document,
you first set the defaults for the sheet, then only process the differences.
Paul
From: Hemant Hegde
To: excel-macros@googlegroups.com
Sent: Wed, November 11, 2009 10:55:41 AM
Subject: $$Excel-Macros$$ Re: S
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
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 bo
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 wrote:
> Hi
>
> After a lot of coding and lengthy calculations (takes up to 2 minutes) I get
> a sheet (actually a report)
