Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2020, 05:18 PM
ChiaRaRa ChiaRaRa is offline Opening Word docs via Excel Windows 10 Opening Word docs via Excel Office 2016
Novice
Opening Word docs via Excel
 
Join Date: Jun 2020
Posts: 1
ChiaRaRa is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 06-25-2020, 06:18 PM
macropod's Avatar
macropod macropod is offline Opening Word docs via Excel Windows 7 64bit Opening Word docs via Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For data collection driven from Excel, see, for example: https://www.msofficeforums.com/word-...cel-sheet.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 via Excel Opening word docs Bemklaver Word 1 03-31-2010 02:22 AM
Opening Word docs via Excel Word docs opening as XML jonno112 Word 2 03-23-2010 10:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 AM.


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