Quote:
Originally Posted by macropod
Hi Jaymond,
I have to wonder why you're bothering to use Word at all. From what you've described, it seems to me the lot could be done within Excel.
In any event, to do it in Word, you don't have to select anything - simply tell it which range(s) to work with. As for the run-time error, that'll occur if you're using late binding. Try using '3' instead of 'wdPasteMetafilePicture'.
|
I'll check this "3" in a while, but shortly, the reason I'm using Word is that when I want to print a PDF with six charts with each on it's own page, I have absolutely no idea how to do it with Excel - first page is easy, but I have no idea how to print the second page into the same file, so I decided instead to work with Word in between.