Speech Marks Round Strings

  • 13 years ago

    I am using VBA to output data from a spreadsheet into another file. It works fine except that strings are shown with speech marks front and back and I don't want them.

    Does anyone know how I can lose these?



  • 12 years ago

    You can try removing them from the string.

    The Inverted Comma is Chr(34)


    sString = Replace(sString, Chr(34), "")


Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The question of whether computers can think is just like the question of whether submarines can swim.” - Edsger W. Dijkstra