SaveAs .txt extension, but need format without quotes

One approach is to send line by line to text file using the print method as opposed to write method because it does not add the double quotes like write does. Are each of your lines above the contents of one cell?

This should remove extra double quotes from txt file.

Please Login or Register  to view this content.

Originally Posted by Maudibe

One approach is to send line by line to text file using the print method as opposed to write method because it does not add the double quotes like write does. Are each of your lines above the contents of one cell?

Thanks Maudibe, If I save the format = xlTextPrinter it gets me closer but lhe lines are too long and I get a Charage Return at the "Inventory" that is not desired.

Originally Posted by jindon

This should remove extra double quotes from txt file.

Please Login or Register  to view this content.

Looks interesting let me see if I adapt this code for my application. Thanks!

Originally Posted by jindon

This should remove extra double quotes from txt file.

Please Login or Register  to view this content.

Hi jindon, I have it working as planned but I have a list of 1900 of these text files all in the same folder I have to process. I am trting to make the file to open a variable. I replaced one line in your code to:

Please Login or Register  to view this content.

where "mypath" is the path to the directory and "myval" is the name of the file. It does not work. Any ideas?

Try change like this
Your code

Please Login or Register  to view this content.

And change to

Please Login or Register  to view this content.

Originally Posted by jindon

Try change like this
Your code

Please Login or Register  to view this content.

And change to

Please Login or Register  to view this content.

Hi jindon, WOW I am impressed. Your VBA coding skills are very impressive. I made the changes you suggested and the VBA code ran without and issues. Thank you so much!!!