Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export from Excel to text file with a twist
I'm new to VB and would really appreciate any help.
What I'm trying to do is export with out any prompts or just to be prompted once for the locations were to save the new text files. If that's not possible create the text files in the same directory as the excel file What I'm trying to do is export column B to a text file and uses the name in column A as the text file name. Column A has over a 150 different site codes and B will always have text (example below). Here is an example of my sheet: A B Site Context HPW smithc,ou=users,ou=wwmg,ou=hpw,ou=na,o=tmt PLB jonesh,ou=users,ou=pgr,ou=plb,ou=na,o=tmt LVL thomass,ou=users,ou=pgr,ou=lvl,ou=na,o=tmt LVL johno,ou=users,ou=pgr,ou=lvl,ou=na,o=tmt HPW lbersoni,ou=users,ou=wwmg,ou=hpw,ou=na,o=tmt PLB masonp,ou=users,ou=pgr,ou=plb,ou=na,o=tmt What I'm trying to get is HPW.txt and inside smithc,ou=users,ou=wwmg,ou=hpw,ou=na,o=tmt bersoni,ou=users,ou=wwmg,ou=hpw,ou=na,o=tmt LVL.txt thomass,ou=users,ou=pgr,ou=lvl,ou=na,o=tmt johno,ou=users,ou=pgr,ou=lvl,ou=na,o=tmt And so on. I have learned how to extract data manually from this group, but I would love to be able to do it automatically. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export excel colonm to a single text file | Excel Discussion (Misc queries) | |||
How can I export text from excel autoshapes to a text file? | Excel Discussion (Misc queries) | |||
export excel spreasheet into a text file | Excel Programming | |||
export excel file as csv with text delimiter of " | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |