| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export specific cell data to txt delimited file
You may be able to create formulas such as VLOOKUP or paste as links
to another sheet and then save that page as a text file. If it is more complex than that I recommend looking in to the following commands: Open "filename.txt" For Append As #1 Write #1, yourDataVariable Close #1 Also, you may do "Output" instead of "Append" to create a new file. Billkamm irc.24oz.net #Excel "Aldo" wrote in message ... I have a workbook with several worksheets that are all identical in design. I would like to take data from specific cells throughout the workbook and place the data into a .txt file for merge purposes. Each set of data are in one column in three cells. Is there an example of this somewhere. I'm not a programmer, but have managed to adapt examples to specific needs. Any suggestions are welcome. Thanks, Aldo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do export Excel file to .txt delimited by "^"? | Excel Discussion (Misc queries) | |||
| Why can't I Export selected cells to tab-delimited text file? | Excel Discussion (Misc queries) | |||
| Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
| Open delimited text file to excel without changing data in that file | Excel Programming | |||
Threaded Mode
