timoteoga
asked on
Dumping Excel file to txt file adding double quotes
I have an excel file that I am saving as a txt (tab delinmited) file for import into another system. Everytime I save to txt, it is adding double quotes in front of every line in the txt file. I can see them when I open in notepad. How can I change the xlsx file it so that it doesn't do that? Help, please!
Sample of the Excel data attached
Test.xlsx
Sample of the Excel data attached
Test.xlsx
Another thing you can do, is select all the data you want.... copy/paste into notepad and it will be Tab delimited by default, without quotes...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the following thread, the people resolved the issue with simple code:
Sub exportdata()
Cells.Select
Selection.Copy
Shell "notepad.exe", vbNormalFocus
SendKeys "^V"
SendKeys "%fa"
End Sub
http://www.ozgrid.com/forum/showthread.php?t=18333&page=1
Sub exportdata()
Cells.Select
Selection.Copy
Shell "notepad.exe", vbNormalFocus
SendKeys "^V"
SendKeys "%fa"
End Sub
http://www.ozgrid.com/forum/showthread.php?t=18333&page=1
I'm not sure if there is a way to turn it off...but why not just do a find/replace in notepad to remove all the double quotes?