Posts: 1
Threads: 1
Joined: May 2007
Hello, I am running a macro for work, but in order for our system to recognize the files, it has to be in text tab delimited. I know how to save a file in text format(.txt), but is there a code I can use so it is saved in text tab delimited?
Posts: 1,769
Threads: 410
Joined: Feb 2003
well, if your saving it from excel you just tell it to save it with a tab between each field. if you have the values of each field, you can manually build the tab-delimiter into the text string line by line but i don't think you have that option since the files are already there but just not tab-delimited.
Posts: 1,769
Threads: 410
Joined: Feb 2003
BTW: i posted 2 lessons on strings in general.
either one may give you some ideas as to what to do here.