[dba-Tech] Word VBA problem

Good work Jon...I will remember this.

Jim



-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Tydda Jon -
Slough
Sent: Monday, November 22, 2010 7:19 AM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Word VBA problem

I found the solution...

To refer to the first object, you need to use this syntax:

        ActiveDocument.InlineShapes(1).Select
        Selection.InlineShapes(1).Fill.Solid

To refer to the second object, you need this one:

        ActiveDocument.InlineShapes(2).Select
        Selection.InlineShapes(1).Fill.Solid

Using InlineShapes(1) and (2) to refer to the object when it's not selected,
but then using InlineShapes(1) to refer to it thereafter. Confused? Me too!


Jon


_____________________________________________
From:   Tydda Jon - Slough
Sent:   19 November 2010 11:48
To:     'Discussion of Hardware and Software issues'
Subject:        Word VBA problem

Hi all

I'm using Word 2003, and I'm having trouble with some vba code that's been
shoved at me...

My document has two images in it, I've written code (well, recorded it) to
resize them and position them on the page as necessary. The only thing is
that the Macro recorder doesn't let me select the image from the page (it
also doesn't let me open the header/footer sections either, but that's
another story). How do I tell my bits of code which images I need to resize?
I'm familiar with Excel vba, and I thought that it would be vaguely similar,
but I'm really having trouble finding the object to reference...

Any clues?


Jon



  ________________________________
This communication and its attachments, if any, may contain confidential and
privileged information the use of which by other persons or entities than
the intended recipient is prohibited. If you receive this transmission in
error, please contact the sender immediately and delete the material from
your system.
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com