Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Excel File in Use Notification Missing?? | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |