double quotes

[Kramer]

Hello,

Because of limitations in my finance program, I'll periodically
export the data to a text file, import the text file to Excel, where I
manipulate the data as required. I then reverse the steps, saving the
Excel file as text, then import the new text file back to my finance
program. It all works Ok except for one thing - the amounts are
stored in the program with a T in front, e.g., 100.00 would be T100.00.
The problem is with larger amounts that involve a comma, such as
1,000.00 which would be T1,000.00. Excel insists on saving it with
double quotes around it, "T1,000.00", which fouls up my finance
program, but not around T100.00. I can run the text file through my
word processor and remove the double quotes, but I'd like to avoid
the extra step. Any ideas? Thanks,

Dave

 

[Dave Peterson]

Maybe you could write your own saver program.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

 

[Kramer]

Dave,

After browsing those websites, I was able to write a simple but
effective program that solved my problem. Thanks for this,

Dave Unger