Using quotation " in string 1

[VBAguy22]

Hi,
How would I use quotations inside a strng? Wouldn't it end the string?

THNX

 

[fredericofonseca]

you "escape" them.

E.g. if you need a " on a string you do "abc""abc"
final string if you display it is
abc"abc

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

Another way is to play with Chr(34).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886