illegal characters in description

[bob_clark5J5M8]

Hi all,

Some of our drawings use double quotes in their description, eg 6"

I read the description iproperty from the drawing file and try to write this to an excel sheet and it throws and error. Removing the double quotes and replacing with the word inch, allows the program to work. Does anyone have a workaround that would allow the use of double quotes in a description to enable successful export to an xls?

[bob_clark5J5M8]

I figured out that

Description = "6""" & "Buckle Arrestor"

gives a value of 6" Buckle Arrestor 

I think I can work it out, if not I'll come back

[WCrihfield]

Hi @bob_clark5J5M8.  Just another way to do it.  You may have already come across this, but you can also use 'Chr(34)' (Link1, Link2, Link3) to represent a double quotation mark character in a String.