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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
309
Dan_W
D
M
  • Solved
Word Header Text
Replies
1
Views
139
RoryA
RoryA
H
  • Question Question
VBA to Shift Table Layout from right to left in Excel
Replies
2
Views
68
Peter_SSs
Peter_SSs
JenniferMurphy
  • Question Question
Is there a way to emulate a junction table in Excel?
Replies
1
Views
128
alansidman
A
M
  • Question Question
Dynamic link from Word to Excel...
Replies
8
Views
197
Matteo85
M

Forum statistics

Threads
1,223,630
Messages
6,173,454
Members
452,514
Latest member
cjkelly15

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