I have been getting extra quotation marks on my products when uploading my tab delimited product feed to various shopping engines.
I found a macro that removes the quotations but when I view the output file in notepad I see the quotation marks are gone but now the fields are separated by commas. Is it still a tab delimited file or so I need to keep searching for a different macro? I pasted the macro below.
Public Sub TextNoModification()
Const DELIMITER As String = "," 'or "|", vbTab, etc.
Dim myRecord As Range
Dim myField As Range
Dim nFileNum As Long
Dim sOut As String
nFileNum = FreeFile
Open "Test.txt" For Output As #nFileNum
For Each myRecord In Range("A1:A" & _
Range("A" & Rows.Count).End(xlUp).Row)
With myRecord
For Each myField In Range(.Cells(1), _
Cells(.Row, Columns.Count).End(xlToLeft))
sOut = sOut & DELIMITER & myField.Text
Next myField
Print #nFileNum, Mid(sOut, 2)
sOut = Empty
End With
Next myRecord
Close #nFileNum
End Sub
Bookmarks