Chr(34)? What is this?

[greegan]

I'm familiar with chr(10) and chr(13) but i'm not familiar with Chr(34). What is Chr(34)?

-- g

 

[GlennUK]

I believe that is the double-quote.

 

[Leith Ross]

Hello greegan,

It is the double quote character.

Sincerely,
Leith Ross

 

[greegan]

Thank you to both of you.
Under what circumstances would it be beneficial for someone to use that in a code?

-- g

 

[Leith Ross]

Hello greegan,

It is most commonly used to insert a double within a string. There are times when enclosing double quotes within double quotes is confusing. Using this representation, although more code, can make the string easier to read and understand. The lines below produce the same result, the file name includes quotes, but adding Chr(34) makes this more clear.

       CmdLine1 = "-min -a -en " & Chr$(34) & "C:\Documents and Settings\Reports.xls" & Chr$(34)
   
         
       CmdLine2 = "-min -a -en " & """C:\Documents and Settings\Reports.xls"""

 

[greegan]

very cool, thank you

-- g