excel vba to remove first row from each table in word document

		Microsoft Office Forums > Microsoft Word > Word VBA
excel vba to remove first row from each table in word document

FAQ

Thread Tools

Display Modes

#11

10-21-2015, 02:22 AM

gmayor

Windows 7 64bit excel vba to remove first row from each table in word document

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,138

If you are referring to the earlier macro, this addresses the workbook with the variable xlBook. To insert columns between A & B and between B & C locate the line

Code:

xlBook.sheets(1).Range("A1").PasteSpecial ("HTML")

and after it add the lines

Code:

xlBook.sheets(1).Range("B1").EntireColumn.Insert
xlBook.sheets(1).Range("D1").EntireColumn.Insert

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Macro to remove Metadata to include Excel and Powerpoint files.	Dan_M	Word VBA	2	04-04-2018 05:09 AM
Creating a table in one document of WORD from EXCEL with Mail Merge	Joseph.Comerford@bentley.	Mail Merge	1	04-18-2015 01:19 AM
How to remove text from Word Document	foneunlocker	Word	3	11-28-2014 12:51 AM
VBA Code to take data from a table in word document and place it in a summary table	VBLearner	Word VBA	1	03-09-2014 08:42 PM
Remove all images from a Mac OS X Word 2008 Document?	qcom	Drawing and Graphics	0	04-23-2011 06:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:39 AM.