Vba excel add tables & shapes in word
in [Word VBA]
|
Prev: Populate a footer on a protected form with text from mixture of text form fields & drop down form filed
Next: Find and replace text thats not wdAlignParagraphCenter alignment
From: hcaoelgod on 25 May 2010 02:16 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 -- H. C.
From: Jay Freedman on 25 May 2010 08:11
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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 24 May 2010 23:16:01 -0700, hcaoelgod <hcaoelgod(a)discussions.microsoft.com> wrote: >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 |