Community discussion forum

Speech Marks Round Strings

• • Reply

  8 months ago

  by KitPrime

  Kit Prime

  , United Kingdom

  Joined 1 year 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  7 months ago

  by Jugatsu

  Jugatsu

  , United Kingdom

  Joined 2 years ago

  You can try removing them from the string.

  The Inverted Comma is Chr(34)

  Try

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

   

  Report abuse