printing a quotation mark in a text file

[stephen]

Hello,

please help with producing something like this in a text file from VBA:

aaa "bbb"

I am trying with

exestr="aaa \"bbb\""
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("H:\qq.bat", True)
a.writeline (exestr)
a.Close

It is a question of escaping characters in VBA. Or if you could tell me how
to pass an argument containing spaces to a script (python,perl,R) from VBA?

 

[Smallweed]

I'd use chr(34) as the double quotes

 

[JRForm]

Try this exestr=""" & "aaa \"bbb\" & """ &

 

[JRForm]

Oops this works better!

exestr = "aaa\" & """" & "bbb\" & """"