accessing avery label table in macro

littlepeaks · #6 08-07-2022, 06:23 PM

Never mind-- I opened up the VBA editor in Word , and looked up "Tables" in the "Help", "Word Object Model Reference". It told me what I wanted to know.

Basically I can use:

strLabelText = ActiveDocument.Tables(1).Cell(1,1).Range.Text 'Copies the text
ActiveDocument.Tables(1).Cell(2,1).Range.Text= strLabelText 'Pastes the text into the cell below

This requires a lot more coding and cleaning up, but I could not figure out how to access the table. I have something to work with now.

Thanks again.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Saving Avery Label 8376	fsinclaire	Word	1	04-30-2022 09:12 AM
Accessing the format tab with the macro recorder	reneemettrie	Word VBA	6	01-10-2020 12:03 PM
Avery Label Templates, editing rows/spacing	rainandwind_95448	Word	2	12-13-2015 08:05 AM
Avery Label Template for Word 2003?	Clueless in Seattle	Word	2	03-31-2015 06:15 AM
Having trouble using Avery 4014 label to print multiple pages	Dickie	Mail Merge	1	09-29-2013 07:28 PM