![]() |
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