View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
P. Scaram P. Scaram is offline
external usenet poster
 
Posts: 1
Default 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