I am working on a spreadsheet and I am trying to export to a trxt file. The
problem that I am running into is when a cell contains a comma it puts quotes
around the text. These are configs for cisco routers and the quotes will
cause problems. I have already written a macro to create the file and save
it. Thank you in advance for your help

"Jwiener3" wrote:

I am working on a spreadsheet and I am trying to export to a trxt file. The
problem that I am running into is when a cell contains a comma it puts quotes
around the text. These are configs for cisco routers and the quotes will
cause problems. I have already written a macro to create the file and save
it. Thank you in advance for your help

Is it possible for you to copy the text and paste it directly into Word?
This could probably be done under macro control if necessary.

J,

Try the Text Write Program at www.smokeylake.com/excel. In sheet Setup,
leave the "bracketing (text qualifier)" field empty.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jwiener3" wrote in message
...
I am working on a spreadsheet and I am trying to export to a trxt file. The
problem that I am running into is when a cell contains a comma it puts
quotes
around the text. These are configs for cisco routers and the quotes will
cause problems. I have already written a macro to create the file and save
it. Thank you in advance for your help

It may be possible but I am not aware how to do this with a macro. It just
needs to be a text document? Any suggestions?

"bigwheel" wrote:

"Jwiener3" wrote:

I am working on a spreadsheet and I am trying to export to a trxt file. The
problem that I am running into is when a cell contains a comma it puts quotes
around the text. These are configs for cisco routers and the quotes will
cause problems. I have already written a macro to create the file and save
it. Thank you in advance for your help

Is it possible for you to copy the text and paste it directly into Word?
This could probably be done under macro control if necessary.