+ Reply to Thread
Results 1 to 3 of 3

Import multiple excel tables at once.

  1. #1
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    42

    Import multiple excel tables at once.

    Hi. Just wanted to ask a quick question regarding importing excel tables.


    Currently, I have to manually copy paste 80 tables into 80 different pages onto a word document. Is there a way I can copy all the tables at once and paste where each table lands on a different page?

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    159

    Re: Import multiple excel tables at once.

    Hi Kris01. Every time you copy something it replaces what is on the clipboard. I do not know of a way to partition this function. I have had to create documents of this nature in the past. What I did to resolve it was to create an excel document that looks like a Word document page for page and line for line, but it is an Excel document. It can be formatted to look just like a Word document. If the pages are basically identical, create one, then copy it and make all of the adjustments to your tables. That way you can use formulas to update your data without copy/paste, then "convert", print, PDF, or however you present it quickly.

    Squeaky.

  3. #3
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013; 365
    Posts
    221

    Re: Import multiple excel tables at once.

    I think it's possible to paste them to word bookmarks.
    You will need, of course, to make 80 bookmarks in Word for the 80 ranges (tables) in Excel.

    I used bookmark inserting cell values (eg. Range("A1").value) from Excel to Word bookmarks. Haven't done it with ranges (eg Range("A1:C8")), but I'm sure it can be done with the proper references and code in Excel.

    The solution depends on how far you want to go - either take Squeaky's proposition and arrange tables in Excel in such a manner that 1 copy / paste will get them exactly how you want in Word, either get VBA to do it for you and work on a macro to do that.
    Last edited by Mrrrr; 10-15-2020 at 12:52 AM.
    To show your appreciation
    Click ★ Add reputation!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Import Multiple Word Tables Into Excel Worksheet
    By bigkahuna2187 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-10-2014, 03:18 PM
  2. Import tables from multiple Word files into a sheet of Excel
    By magdy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 03:53 AM
  3. Import Multiple Tables From Access
    By tommyfernandez in forum Excel General
    Replies: 2
    Last Post: 12-10-2008, 04:43 PM
  4. Replies: 0
    Last Post: 07-06-2006, 12:50 AM
  5. [SOLVED] How import multiple tables from same web page (Web Query)?
    By joeu2004@hotmail.com in forum Excel General
    Replies: 2
    Last Post: 03-08-2006, 07:45 PM
  6. Import data from multiple tables
    By Pontificateur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2006, 02:40 PM
  7. Automating import of Word tables into Excel
    By Han in forum Excel General
    Replies: 0
    Last Post: 01-18-2006, 04:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1