Speech Marks Round Strings

• • Reply

  13 years ago

  by KitPrime

  Kit Prime

  , United Kingdom

  Joined 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?

  Thanks 

  Kit

  Report abuse
• • Reply

  12 years ago

  by Jugatsu

  Jugatsu

  , United Kingdom

  Joined 15 years ago

  You can try removing them from the string.

  The Inverted Comma is Chr(34)

  Try

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

   

  Report abuse