G
Guest
Hi all.
First of all, I want to apologize for my poor english.
I have an Access database with a memo field that contains rtf text. I
export data by using VBA to an Excel Sheet that generate a graphic, and other
text to different cells.
The problem is when I send the rtf to only one cell, I can send the text,
but appear the Carriage Returns or Line Feeds as a square, and the rich
format dissapear.
How can I send the rich format (colors, fonts, etc) and delete those
square characters?
Thanks to everybody.
P.D. I'm using Access and Excel XP (2002), but code must run on 2000 or 2003
versions, due at my office there are the 3 versions. The Access database has
been generated in Access 2000 format.
First of all, I want to apologize for my poor english.
I have an Access database with a memo field that contains rtf text. I
export data by using VBA to an Excel Sheet that generate a graphic, and other
text to different cells.
The problem is when I send the rtf to only one cell, I can send the text,
but appear the Carriage Returns or Line Feeds as a square, and the rich
format dissapear.
How can I send the rich format (colors, fonts, etc) and delete those
square characters?
Thanks to everybody.
P.D. I'm using Access and Excel XP (2002), but code must run on 2000 or 2003
versions, due at my office there are the 3 versions. The Access database has
been generated in Access 2000 format.