#1
|
|||
|
|||
Opening Word docs via Excel
Hi Macropod - many thanks for your advice throughout https://www.msofficeforums.com/word-...x-files-2.html. I'm attempting to write a macro which manipulates data in Excel on output provided to me via numerous Word documents each quarter (effectively, this piece functions as a data dump of Word docs into Excel).
As a first step, I'd like to have Excel open the first Word doc in the folder without having any Word doc open already - I've made modifications per your comments to adjust this code for Excel, but the first proposed code presupposes you have a Word doc open (since it was intended as a Word macro!). I'll be handing this program over to colleagues and want to minimize potential user error. Let me know your thoughts or if you need further information. Last edited by macropod; 06-25-2020 at 06:14 PM. Reason: Split from: https://www.msofficeforums.com/word-vba/16209-run-macro-multiple-docx-files.html |
#2
|
||||
|
||||
For data collection driven from Excel, see, for example: https://www.msofficeforums.com/word-...cel-sheet.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word creating opening new docs in background??? | FarmerTan | Word | 1 | 09-21-2018 10:54 AM |
My Word docs are opening up as black with white fonts | wmcgrath42 | Word | 2 | 03-21-2018 08:23 PM |
opening downloaded Word docs | drmjdaly | Word | 0 | 11-03-2013 09:48 AM |
Opening word docs | Bemklaver | Word | 1 | 03-31-2010 02:22 AM |
Word docs opening as XML | jonno112 | Word | 2 | 03-23-2010 10:20 PM |