word to Excel
 

I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like "document.line.word. character" ????? i know how to use
functions like mid, left, right but dont know about word line,
character reading.
plz help me
thks in advance


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=514729

word to Excel
 

Why not just try saving the file as text and open it in Excel? That might
be a good place to start.

Tim


"ExcelPower" wrote
in message ...

I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like "document.line.word. character" ????? i know how to use
functions like mid, left, right but dont know about word line,
character reading.
plz help me
thks in advance


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile:
http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=514729

word to Excel
 

Thks Tim but sorry i dont think running away from problem is great
thing
If I know Excel Macro I must learn Word Macro Too.
Any One if know how to read Word line in Excel Macro Plz let me know

with regard

ExcelPower


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=514729