Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-24-2015, 04:26 PM
Guessed's Avatar
Guessed Guessed is offline Extracting Data from Word Documents Windows 7 32bit Extracting Data from Word Documents Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It is possible to do but you would need to write a macro that opens each file, finds the relevant information and copies it to your excel sheet.

This is not a trivial exercise but if your 100 documents are very consistent it is certainly possible.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Data from Word Documents Extracting data, pivot tables, and maybe VBA help? rbexcelhelp Excel Programming 3 05-09-2015 12:13 AM
Extracting Data from Word Documents extracting data from word docs stubevh Word 2 03-04-2015 06:27 PM
Extracting Data from Word Documents formula writing for extracting data jennamae Excel 1 11-15-2013 08:40 PM
Extracting Data from Word Documents Extracting data from excel Eric855 Word 6 07-25-2013 08:02 AM
Extracting Contacts Data from Excel Caesar Outlook 1 05-08-2011 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft