Resize Chart/EnhancedMetaFile after pastespecial into Word

[Bob1980]

hey all,

I was wondering if someone can point me in the right direction with this one. I'm trying to resize an enhancedmetafile after using Word.Application...PasteSpecial. Basically the image is too long, and it extends past the boundaries of the word document page. I'm having a hard time finding the right commands to do this. Also, is there an alternate DataType:= that I can use that will not allow values within the image to be changed after it is pasted into Word? I found out that the enhancedmetafile image allows people to go into the image and change it.

Below is what I have so far. The last area that was commented out was my last attempt to resize this image.

Please Login or Register  to view this content.

I'd appreciate any help with this one.

Thanks!

[Bob1980]

Hey all,

For those of you following this post, I figured out what to do. Below is a copy of the code that scales down the enhancedmetafile down.

Please Login or Register  to view this content.

Enjoy!