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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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
199
NdNoviceHlp
NdNoviceHlp
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
411
Dan_W
D
M
  • Solved
Word Header Text
Replies
1
Views
148
RoryA
RoryA
H
  • Question Question
VBA to Shift Table Layout from right to left in Excel
Replies
2
Views
86
Peter_SSs
Peter_SSs
JenniferMurphy
  • Question Question
Is there a way to emulate a junction table in Excel?
Replies
1
Views
149
alansidman
A

Forum statistics

Threads
1,224,744
Messages
6,180,696
Members
452,994
Latest member
Janick

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