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.
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.