Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Extract MS word data to MS Excel

I gave you the method to control Word from Excel. If that isn't what you
want, then it is unclear what you want.

You can use the Dir command to find all the word files in a directory (see
the help example for a start) or get voluminous examples searching the
google archive for this group.

As far as searching the documents, you can probably get the code you need by
turning on the macro recorder in Word and performing the actions manually.
then generalize that code and combine with the methods in the articles.


--
Regards,
Tom Ogilvy

"GTS " wrote in message
...
Thank you very much, but this is not what i've been looking for. I need
to get data FROM Word TO Excel. I want the macro to find the data
automatically based on the table column in Word. And finally, the marco
should check all Word documents in a directory and do its task.....tough
huh? sorry, but if you can help...

Regards,
G. Tsakalos


---
Message posted from http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract word before / Wanna Learn Excel Discussion (Misc queries) 3 April 9th 09 04:08 PM
How to extract right-most word? [email protected] Excel Worksheet Functions 17 July 5th 07 06:43 PM
Macro to Extract Text From Word Table Into Excel? V. Hatherley Excel Discussion (Misc queries) 1 August 27th 06 04:12 PM
Extract MS Excel Data embedded in MS Word qualityprocess Excel Discussion (Misc queries) 0 April 20th 06 05:52 PM
Extract data (not in table) from Word to Excel hellokitty77 Excel Discussion (Misc queries) 1 January 14th 06 01:51 PM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"