Am stuck on a problem with Automation string character
limitations.

I am using ADODB recordsets and Late Binding Object
Automation to export data from Access to Excel. One of the
fields in this recordset is a memo field which will often
have more than 255 characters. Due to the Automation
Object limitations - only the first 255 character will be
inserted into Excel.
To overcome this problem I am splitting the memo fields
into 255 character chunks which are inserted into seperate
cells with the view of recombining them using the
CONCATENATE function.
After entering the formula in the cell and opening the
resulting file - I find that the formula still only
displays the first 255 characters. If you then select the
cell, click in the formula bar and confirm by pressing
enter - the entire string is then successfully displayed.

To try to overcome this I have tried every possible
combination of range and application recalculates. I have
tried using a find and replace on the "=" in the formula.
I have even tried making the Excel Application visible
during the running of the sub and emulating the cell
selection and confirmation by using SendKeys "{F2}" then
SendKeys "{ENTER}" - but this still does not work.

Any advice that the experienced coders can offer would be
GREATLY appreciated.
I am more than happy to provide more information if required.

Regards,
Matt Slattery