Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-26-2020, 08:55 AM
gedinfo2020 gedinfo2020 is offline Replace " in string sent to output file Windows 10 Replace " in string sent to output file Office 2019
Novice
Replace " in string sent to output file
 
Join Date: Feb 2020
Posts: 4
gedinfo2020 is on a distinguished road
Smile Replace " in string sent to output file

Hello, I am sending a csv formatted data to an output file, and find that the string that I put the data into ends up with " at the start, followed by a CR\LF and " at the end.
I do not directly enter the leading " or the ending CR/LF ".



I have screen shots saved as .png to demonstrate what I mean, but do not have web storage for these.

Via VBA, I wish to eliminate the extra 'formatting', as this causes the csv file to not be imported into Excel correctly.

Thank you for any suggestions.

Last edited by gedinfo2020; 02-26-2020 at 11:35 AM. Reason: attempt to add image attachments
Reply With Quote
 

Tags
word vba "



Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace " in string sent to output file Define custom Cross-reference output format to include "static" text and pg numbers cyclops755 Word VBA 9 01-17-2023 02:42 PM
Replace " in string sent to output file Wildcard replace any string in context with a specified string wardw Word 7 05-07-2018 09:13 AM
Replace " in string sent to output file Advanced Replace -- Incorrect Output Order cheech1981 Word 2 09-18-2017 04:44 PM
Replace " in string sent to output file Way to search for a string in text file, pull out everything until another string? omahadivision Excel Programming 12 11-23-2013 12:10 PM
Replace " in string sent to output file Macro VBA "Save as" with bookmarks in file name string Dom37 Word VBA 2 10-31-2011 03:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft