| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
| Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
| Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
| Printing Word Document using Excel Programming hangs Word | Excel Programming | |||
![ExcelPower[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
