Excel, DB data and RTF

I

IH870

Good morning to you all
I have a sql server table in which there's an attribute containing an rtf
string; something like
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0
Times New Roman;}{\f1\fnil\fcharset0 Verdana;}}

\viewkind4\uc1\pard\ul\b\i\f0\fs32 pippo\ulnone\b0\i0\f1\fs18

\par }

Well, using a query to an external source I get the string, but... exactly
as you read it here above. I do need to transform it in something readeable.
I'd love a function like: "=GetRTF(A1)" ;) but I'm not able to find it and
at the same time I cannot find nothing in VBA.

Any hints is welcome
All the best
pf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top