VBA code to collect tables from multiple word docs to excel

G

Ginoji

New Member
Joined
Dec 2, 2020
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
Please take a look at the attached screenshot
I have more than 5 files like this and more than 14 tables in each file
I need to compile it in one word file also I have 4 tables I need to get from an Excel file

Is there any way to collect the information in each table instead of opening each one and copy & paste manually?

Thanks in advance
Screenshot 2021-09-24 000049.png
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

A
  • Solved
Automate data export from multiple word tables into excel
Replies
8
Views
357
NdNoviceHlp
NdNoviceHlp
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
498
Dan_W
D
M
  • Solved
Word Header Text
Replies
1
Views
168
RoryA
RoryA
H
  • Question Question
VBA to Shift Table Layout from right to left in Excel
Replies
2
Views
124
Peter_SSs
Peter_SSs
JenniferMurphy
  • Question Question
Is there a way to emulate a junction table in Excel?
Replies
1
Views
166
alansidman
alansidman

Forum statistics

Threads
1,225,627
Messages
6,186,100
Members
453,337
Latest member
fiaz ahmad

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top