All,
I am using Access to automate Excel. I have a memo field in Access that contains Line Feeds (Ascii character 10). I am using the following command to enter the text into the cell:
wks.cells(iRow, iCol) = strData
However, I get an error when I do this. I believe this is because I have Line Feeds in the strData variable. When I replace them with Carriage Returns, the code works, but the text in Excel has boxes. I would like to retain the line feeds in Excel, similar to what would happen if I copy the text, go into Excel, hit F2, and Paste.
Can anyone help?
I am using Access to automate Excel. I have a memo field in Access that contains Line Feeds (Ascii character 10). I am using the following command to enter the text into the cell:
wks.cells(iRow, iCol) = strData
However, I get an error when I do this. I believe this is because I have Line Feeds in the strData variable. When I replace them with Carriage Returns, the code works, but the text in Excel has boxes. I would like to retain the line feeds in Excel, similar to what would happen if I copy the text, go into Excel, hit F2, and Paste.
Can anyone help?