long memo MSAccessFileds give error in excell 2003 object library

P

P. Scaram

Dear Sir/Madame,

long memo access fields when loaded to excel 2003 with vb create an error
1004 "Application defined or Object Defined error".

I am reading a recordset from a MS Access application and load the fields in
excell 2003 cell by cell, using the excel object library 11 and the command
worksheet.Cells(rownumber, columnnumber) = Me.Notes
The Notes field is a memo field and when it exceeds a certain length > 300
chrs or something like that, it generates an Application-Defined or
Object_Defined error.

This error was not happening with excell 2000 and the excel object library 9.

Any service packages for that.

thank you in advance

P.Scaram
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

long memo access fields when loaded to excel 2003 with vb 0
Get Range object from Cell Row and Column No. 1
Application-defined or Object-defined-error when changing color in 1
Trouble using VLookup in VBA 4
Create Hyperlink in VBA 7
12.0 Object Library Automatically inserted in 2003 VBA 0
Run-Time error 1004 Application defined or object defined error - 0
Pivot tables in Excel 2003 and 2007 0

Top