Exporting from Excel to a text file
 

How do I export only the visible cells, not the hidden ones, in an Excel
spreadsheet to a text file?

Copy those visible cells to a new worksheet nad save from there (as .txt)?

Select your range
edit|goto|Special|visible cells only
edit|copy
to the new sheet
edit|paste



Josh Brien wrote:

How do I export only the visible cells, not the hidden ones, in an Excel
spreadsheet to a text file?

--

Dave Peterson

I was actually wanting to use a filter to gain the row of information I need
and export them to the text file using a button with a macro attached if it's
possible.

"Dave Peterson" wrote:

Copy those visible cells to a new worksheet nad save from there (as .txt)?

Select your range
edit|goto|Special|visible cells only
edit|copy
to the new sheet
edit|paste



Josh Brien wrote:

How do I export only the visible cells, not the hidden ones, in an Excel
spreadsheet to a text file?

--

Dave Peterson

You could create a macro that would loop through the rows/cells and check the
columnwidth/rowheight. Then write the values out to that text file.

If you want to do that, you may want to review some code that other's have
written:

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

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

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

===
But I think I'd record a macro when I applied the filter and did that stuff
manually. If you need help, post back with what you've tried and I'm sure
someone will jump in to help.

Josh Brien wrote:

I was actually wanting to use a filter to gain the row of information I need
and export them to the text file using a button with a macro attached if it's
possible.

"Dave Peterson" wrote:

Copy those visible cells to a new worksheet nad save from there (as .txt)?

Select your range
edit|goto|Special|visible cells only
edit|copy
to the new sheet
edit|paste



Josh Brien wrote:

How do I export only the visible cells, not the hidden ones, in an Excel
spreadsheet to a text file?

--

Dave Peterson


--

Dave Peterson