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
Want to boost your .NET application performance?
Some developers always seem to write efficient and lightening-fast code. What is their secret? It’s ANTS Profiler. “We improved the performance of the application up to 10 times” Dan Ports, Intrigma.
Try it for yourself now.
You can try removing them from the string.
The Inverted Comma is Chr(34)
Try
sString = Replace(sString, Chr(34), "")