word to Excel

  • Thread starter Thread starter ExcelPower
  • Start date Start date
E

ExcelPower

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
 
Why not just try saving the file as text and open it in Excel? That might
be a good place to start.

Tim
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tranfer data from Excel to word (Docx) via VBA in Excel 5
Word to Excel: Export comments with text and line number 0
Find/Replace MSWord wildcard characters from within Excel 6
Excel spreadsheet to Word document 1
Exporting from excel to word: issue with data displayed in word do 1
Saving a Word document as PDF from en Excel macro 2
writing excel data into word document 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top