Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-13-2019, 03:42 PM
Ethen5155 Ethen5155 is offline gather specfic Tables to one file Windows 10 gather specfic Tables to one file Office 2016
Novice
gather specfic Tables to one file
 
Join Date: Nov 2019
Posts: 5
Ethen5155 is on a distinguished road
Angry gather specfic Tables to one file

Hi all,

well i'm in bad situation in dealing with huge number of files for translation in docx files

i'm trying to find a code that can go through defined path folder by prompt window or anything else,



then copy the 4th table as shown below



and gather all of tables to the first file and separate between them by a paragraph mark



i have attached sample files for before and after


and here is code that can copy specific table to a new document but i couldn't make it go through multiple files with the separator and when it copy a table it doesn't copy the format, table and cell sizes well



Quote:
Sub ExtractSpecificTables()
Dim objTable As Table
Dim objDoc As Document
Dim objNewDoc As Document
Dim objRange As Range
Dim strTable As String

strTable = InputBox("Enter the table number: ")
Set objDoc = ActiveDocument


Set objNewDoc = Documents.Add

objDoc.Tables(strTable).Range.Select
Selection.Copy

Set objRange = objNewDoc.Range
objRange.Collapse Direction:=wdCollapseEnd
objRange.PasteSpecial DataType:=wdPasteRTF

End Sub


Many thanks in advance

Cheers

Cross - Posting:gather all Tables to one file
Attached Files
File Type: zip Before.zip (104.1 KB, 9 views)
File Type: zip After.zip (22.3 KB, 10 views)

Last edited by Ethen5155; 11-14-2019 at 05:53 AM.
Reply With Quote
 

Tags
copy, tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to gather data from one workbook and pasting it in a data set lwbarnes Excel Programming 1 11-02-2016 07:05 PM
Problem with saving Word file that is connected to Excel files that uses Powerpivot tables, charts Paul-NYS Office 2 08-24-2016 06:00 AM
import tables from an Excel file, but from different sheets rabit2 Word 2 04-20-2016 05:58 AM
gather specfic Tables to one file On Open MsgBox for use in Template sent out to colleagues to gather information Lancashire Lad Word VBA 2 10-26-2015 10:22 AM
gather specfic Tables to one file excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.


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