Vba excel add tables & shapes in word

H

hcaoelgod

Working with Office 2007 i build a word document from within excel.
I start with a empty document, and sets the size and orientation from excel.
I can add tables and shapes to the first page.
When adding to second page tables are placed correct, but shapes are placed
on first page.
How do i get the shapes intended for page 2 to appear on page 2?
Thanks
 
J

Jay Freedman

The .Shapes.AddShape method (as well as the other .AddXXX methods) has
an optional argument named Anchor. In order to place the shape
anywhere other than the top left corner of page 1, you must supply a
Range as the value of the Anchor argument. Typically the Range is the
range of a paragraph in the desired location, and the shape becomes
anchored to that paragraph. A shape will always appear on the same
page as its anchor; from there you can adjust its horizontal and
vertical position in various ways.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top