Send rtf to excel cells

H

Horus

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.
 
B

Bob Buckland ?:-\)

Hi Horus,

You may want to use the link below to post the question in the MS Office Access newsgroup. When posting there include the version
of Access and Excel you are using.

=======
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.>>
--
Let us know if this has helped you,

Bob Buckland ?:)
MS Office System Products MVP
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
H

Horus

Hi Bob,

Many thanks for your answer. I'll post the question on the Access newsgroup.

Best regards.
 
Top