On Thursday 27 July 2006 19:49, Orlini, Robert wrote:
Anyone ever run into this before?
Yeah.
You'll never guess what is wrong :-)
--
Tom Chiverton, hay - it's Friday :-)
This email is sent for and on behalf of Halliwells LLP.
Halliwells
Using Microsoft Excel a user keeps getting a Not enough system resources to
display completely message.
Anyone ever run into this before?
Thank you,
Robert O.
HWW
~|
Introducing the Fusion Authority Quarterly Update. 80
Hi Michael,
This is trivial to do using VBScript in Excel, assuming that you're able to
run macros.Are your dynamic rows on the same worksheet as the cell
containing your number of customers? If you decrease the number of
customers, are rows deleted?
If you want, send me your spreadsheet off
8:41 AM
To: CF-Talk
Subject: Re: OT: Excel ?
Hi Michael,
This is trivial to do using VBScript in Excel, assuming that you're able to
run macros.Are your dynamic rows on the same worksheet as the cell
containing your number of customers? If you decrease the number of
customers, are rows deleted
Does anyone know how to dynamically add rows in excel?
Here is what I have. I have a queue simulation setup in excel whereby in a
cell you specify the number of customers as an interger. So for instance,
500. When I put that number in there I would to dynamically create 500 rows.
Now for the
Hi list, a customer of
mine doesn't like
MS-Access at all.
She likes to edit/delete
data with MS-Excel.
But the backend for
the CF-App is in MS-Access.
Is there any option
she can edit her data
with Excel ?
I thought of reimporting the data
to access via an Excel ODBC, but
the data-changes are
(Posted this slightly before Michael's server went kablooey, so I'm trying
again...)
Any of you folks know a way to get Excel, when saving as a CSV
(comma-delimited) format, to put the proper amount of commas on each for
rows that don't have all the data?
Say I've got five columns being used,
Anybody know a good Excel Group or resource for tech help?
- j
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ:
How can I keep Excel from formatting columns when I open a .csv file? I
have a serial number column that can be all numbers, or a combinantion of
numbers and text. When Excel sees a long string of numbers it formats it in
scientific notation.
Thanks,
Steven D Dworman
set the column as text
On Wed, 6 Mar 2002, Steven Dworman wrote:
How can I keep Excel from formatting columns when I open a .csv file? I
have a serial number column that can be all numbers, or a combinantion of
numbers and text. When Excel sees a long string of numbers it formats it
in
i don't want the user to have to change anything on the fly. i want excel
to not apply its own formatting.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 1:39 PM
To: CF-Talk
Subject: Re: OT: excel
set the column as text
On Wed, 6 Mar 2002
, 2002 1:39 PM
To: CF-Talk
Subject: Re: OT: excel
set the column as text
On Wed, 6 Mar 2002, Steven Dworman wrote:
How can I keep Excel from formatting columns when I open a .csv file?
I
have a serial number column that can be all numbers, or a combinantion
of
numbers and text. When
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 10:58 AM
To: CF-Talk
Subject: RE: OT: excel
Put a ' in front of the text in the file... Excel will treat it as a
string that way.
i don't want the user to have to change anything on the fly. i want ex
ce
l
to not apply its own formatting
Sorry about the OT
But does anyone know how to turn Excel spreadsheet cells into drop
down menus?
I see how to add an ActiveX control or a form combo-box, but I was
told there is a way to turn the column into drop downs without having to add
one to each cell.
Thanks for any
I'm using DTS(Data Transformation Services) to import an excel file to SQL 7. My
problem is that DTS throws an error on numbers and dates unless the field in the SQL
table is VarChar. It will not put a number into a number or a date into a date because
everthing in Excel is viewed as a string.
15 matches
Mail list logo