From access, SCALE picture in Word after using AddPicture method

  • Thread starter Lance.Carter via AccessMonster.com
  • Start date
L

Lance.Carter via AccessMonster.com

I am exporting a recordset of data into a word template which works great.
However i want to sign the word document using a path/file name within my
recordset.

I've tried several ways of writing the code. Basically, this imports the
picture and moves it:

wdapp.activedocument.Shapes.AddPicture (rst.Fields(49))

wdapp.activedocument.Shapes(1).Left = 100
wdapp.activedocument.Shapes(1).Top = 100

However i can't get any scaling working...such as:

wdapp.activedocument.Shapes(1).ScaleHeight (0.1)
wdapp.activedocument.Shapes(1).ScaleWidth (0.1)

If anyone knows the correct syntax/mechanism i can scale the picture it would
be appreciated.

Lance

p.s. i can't just decrease the original picture size...the picture starts
large and holds a good resolution so that when printed it retains a good
quality.
 
L

Lance.Carter via AccessMonster.com

After prompting from another post, i realise now i had Reference to 'office
10.0' not 'Word 10.0'. which has worked fine for six months until this
stopped me in my tracks!

Thanks for looking..problem solved.
 

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