ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   long memo access fields when loaded to excel 2003 with vb (https://www.excelbanter.com/excel-programming/401483-long-memo-access-fields-when-loaded-excel-2003-vbulletin.html)

P. Scaram

long memo access fields when loaded to excel 2003 with vb
 
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


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com