Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obtain Word Doc Info Into Excel
Hello. I am using Excel 2000. I am very grateful for all the help I've received here and now I'm asking for your help concerning gathering information from a Word doc into Excel. I wonder if it is possible to "capture" data from a Word doc and save it into an Excel Sheet, thus preserving a "database" of the user's inputs over time. Specifically . . . Idea 1 : If a Word doc existed with a Table of 10 columns and 8 rows, could the entire contents of those 80 fields be saved as a single record (row) in Excel ? That is, into the next empty row on Sheet 1 from columns A to CB (which is 80 columns wide). What VBA code could open the Word doc, obtain the 80 fields of data and copy it into Excel ? Idea 2: Very similar. If a Word doc existed as a Word Fill-In Form, say with 25 distinct fields, could such data "capture" also be accomplished into Excel as mentioned above, via VBA ? That is, all 25 fields as a single record in Excel, beginning with column A, at the next available empty row. I know in Excel one means of transferring values is like the code line below. Range("Sales!C12").Value = Range("Inventory!M35").Value (The code above gathers the value from cell M35 on the Inventory Sheet and places it into cell C12 on the Sales Sheet. I am assuming there should be some similar syntax to obtain field data from Word into Excel.) If this is possible, I would appreciate any coding help along these lines. Thank you very much. WayneK -- WayneK ------------------------------------------------------------------------ WayneK's Profile: http://www.excelforum.com/member.php...o&userid=23037 View this thread: http://www.excelforum.com/showthread...hreadid=388413 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking info from word and excel | Excel Discussion (Misc queries) | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
copying excel info into word | Excel Discussion (Misc queries) | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) | |||
Help with transfering info from Excel to Word | Excel Programming |