I have to import data to a system that wants text input.

Up to now I have generated the necessary character strings in column a of a
standard spreadsheet, copied column A then pasted it into notepad and saved
as .txt.
This works just fine but requires several steps. I would like to simply save
it as .txt from Excel, but Excel adds quote (") marks around each entry.

Is there a way to do this so the quote marks are not added to the character
string. I would like to do this with a MACRO.

Thanks,
Craig

You could use a macro and write code and have complete control over what you
write.

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

Earl's program may work right out of the box.

C Brandt wrote:

I have to import data to a system that wants text input.

Up to now I have generated the necessary character strings in column a of a
standard spreadsheet, copied column A then pasted it into notepad and saved
as .txt.
This works just fine but requires several steps. I would like to simply save
it as .txt from Excel, but Excel adds quote (") marks around each entry.

Is there a way to do this so the quote marks are not added to the character
string. I would like to do this with a MACRO.

Thanks,
Craig

--

Dave Peterson