My problem is that I am trying to p

[grimmy]

My problem is that I am trying to pass a string to a an active x control that requires double quotes in the string.

Test1 = "Word1 "Word2""

Word 2 is the word that I want to appear in double quotes but it does not like this code.
I have tried using a variant and other shot in the dark attempts using brackets and single quotes but cannot find the correct coding.

Please Help......

 

[nickt]

have you tried using the chr() function?

e.g.
test1 = "Word1 " & chr(34) & "Word2" & chr(34)

 

[CCLINT]

You could also try passing it like this:

test1 = "Word1 ""Word2""

 

[grimmy]

Thankyou,
I used the chr function and it worked fine.