Run-time error '7': Out of memory
 

Hi,

I apologize for the large post but I included the code and the body of
problematic text so you can recreate the problem. I am at a loss at
why I am not allowed to write a large chunk of text (see below) to a
cell. I have isolated it to this statement:
vOutputWS.Cells(vCurrentRow, vOutputCurrentColumn).Value = vTextLeft

I am manually parsing a tilde (~) delimited row into separate cells.
When it hits this chunk of text which is assigned to the variable
"vTextLeft" it consistently displays a dialog with the message in the
Title.

The data source that pulls the initial tilde delimited data is coming
from Oracle via ODBC in Excel. The next step is to parse the data into
cells.

Any suggestions?

Excel 2000 on Windows 2000 Professional

Large chunck of text:

-Quickly fill out your basic childcare information on the top left side
of the form. It is your responsibility to give the monthly sign in
sheet to your childcare provider. Keep this form at your provider's
site in a place where it will be easy for you to sign your name. You
must sign your child in and out on the sign in sheet each day. You
must verify, with your signature, the time in and out for each child
every day. This monthly sign in sheet will be your record of the total
hours of childcare provided during the month. It is important that the
childcare sign in sheet is filled in every day you use childcare. It
is your responsibility to sign your children in and out every day. At
the end of the month, you and the childcare provider need to sign your
names at the bottom of the monthly childcare sign in sheet.



-At the end of each month, the other form that you need to complete is
the CW child care eligibility report. You complete section 1 on the
front of the form and sign your name (initials cannot be used). Your
childcare provider completes section 2 on the back of the form. The
information gathered allows the county to confirm that our records have
current and correct childcare information on file. Then you and the
childcare provider sign your name at the bottom of the form.



-After both of these forms are completed, it is your responsibility to
submit them to your childcare worker by the 5th day of the next month.
Here is why: the faster the forms are submitted, the quicker your
childcare provider will receive their payment. This is very important
- otherwise they will not accept your child into care. So, it is
really important that both these forms are submitted on time, in a
complete way, with correct information. When forms are not filled out
completely, have incorrect information, missing signatures or are
turned in late, it will affect your childcare provider's payment. Help
us out by submitting the forms by the 5th of the month. It will make
life easier for you, your children, your provider and the staff at
DSS.



You will receive step-by-step instructions with each of the forms.
These instructions will provide you with the information you need to
complete the forms correctly.


--
rpollard001
------------------------------------------------------------------------
rpollard001's Profile: http://www.excelforum.com/member.php...o&userid=31439
View this thread: http://www.excelforum.com/showthread...hreadid=511295

Run-time error '7': Out of memory
 

Google your error message to see if that helps.

For example:
http://support.microsoft.com/default...;en-us;Q257947
and
http://support.microsoft.com/default...;en-us;Q173182
and there are probably other strange issues.


--
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.


"rpollard001"
wrote in message
...

Hi,

I apologize for the large post but I included the code and the body of
problematic text so you can recreate the problem. I am at a loss at
why I am not allowed to write a large chunk of text (see below) to a
cell. I have isolated it to this statement:
vOutputWS.Cells(vCurrentRow, vOutputCurrentColumn).Value = vTextLeft

I am manually parsing a tilde (~) delimited row into separate cells.
When it hits this chunk of text which is assigned to the variable
"vTextLeft" it consistently displays a dialog with the message in the
Title.

The data source that pulls the initial tilde delimited data is coming
from Oracle via ODBC in Excel. The next step is to parse the data into
cells.

Any suggestions?

Excel 2000 on Windows 2000 Professional

Large chunck of text:

-Quickly fill out your basic childcare information on the top left side
of the form. It is your responsibility to give the monthly sign in
sheet to your childcare provider. Keep this form at your provider's
site in a place where it will be easy for you to sign your name. You
must sign your child in and out on the sign in sheet each day. You
must verify, with your signature, the time in and out for each child
every day. This monthly sign in sheet will be your record of the total
hours of childcare provided during the month. It is important that the
childcare sign in sheet is filled in every day you use childcare. It
is your responsibility to sign your children in and out every day. At
the end of the month, you and the childcare provider need to sign your
names at the bottom of the monthly childcare sign in sheet.



-At the end of each month, the other form that you need to complete is
the CW child care eligibility report. You complete section 1 on the
front of the form and sign your name (initials cannot be used). Your
childcare provider completes section 2 on the back of the form. The
information gathered allows the county to confirm that our records have
current and correct childcare information on file. Then you and the
childcare provider sign your name at the bottom of the form.



-After both of these forms are completed, it is your responsibility to
submit them to your childcare worker by the 5th day of the next month.
Here is why: the faster the forms are submitted, the quicker your
childcare provider will receive their payment. This is very important
- otherwise they will not accept your child into care. So, it is
really important that both these forms are submitted on time, in a
complete way, with correct information. When forms are not filled out
completely, have incorrect information, missing signatures or are
turned in late, it will affect your childcare provider's payment. Help
us out by submitting the forms by the 5th of the month. It will make
life easier for you, your children, your provider and the staff at
DSS.



You will receive step-by-step instructions with each of the forms.
These instructions will provide you with the information you need to
complete the forms correctly.


--
rpollard001
------------------------------------------------------------------------
rpollard001's Profile:
http://www.excelforum.com/member.php...o&userid=31439
View this thread: http://www.excelforum.com/showthread...hreadid=511295