Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Just loaded office 2003 on my new laptop Vista OS. | Excel Discussion (Misc queries) | |||
Access to Excel memo-type field transfer | Excel Discussion (Misc queries) | |||
Access Memo field to Excel Textbox | Excel Programming | |||
Fields in recordset from Access with value Null (empty fields) | Excel Programming | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) |