Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I am trying to find a way to write the text in each row in column A (say) to files defined in column B, does anybody know if this is possible? For example I would have a workbook with Column A as: A1: Jim Dave Ellen Elaine A2: Banker Baker Exec Teacher And column B as: B1: Names.txt B2: Jobs.txt I would like to run a macro to create the external files named in column B with the contents from column A, such that: Names.txt consists of "Jim Dave Ellen Elaine" and Jobs.txt consists of "Banker Baker Exec Teacher" Hope that somebody can point me in the right direction as I'm stumped with this one. Thanks, Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unprotect a write protected file | Excel Discussion (Misc queries) | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Access a excel file through FTP without write protection | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) |