https://www.google.com/#hl=en&gs_nf=1&tok=mwyROkPqXBEFI6bPzbf4PA&cp=17&gs_id=2o&xhr=t&q=excel+import+word+document&pf=p&sclient=psy-ab&oq=excel+import+word&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=33008d434c5e9bd6&biw=1024&bih=644
Don Guillett Microsoft Excel Developer SalesAid Software [email protected] From: .. Sent: Tuesday, July 17, 2012 8:03 AM To: [email protected] Subject: $$Excel-Macros$$ collecting data from a word document into XL sheet Dear All a.. I have a word format where data is collected from salesman. I've enclosed a copy b.. This word doc has questions and answers. Answers are shown highlighted in yellow c.. Is there a way / is there a VBA code to collect these answers in an XL sheet ? One answer per (cell) on a column and each page of the word doc as a row in XL ? d.. A sample XL sheet of what I am requesting / expecting is also enclosed THANKS in advance !!! PS : The final word document would be 100 pages long and hence this request Thanks in advance Best regards -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to [email protected] To unsubscribe, send a blank email to [email protected] -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to [email protected] To unsubscribe, send a blank email to [email protected]
