Hi,

This is next to "Hello World" for you who have programmed Word even a bit. Short and simply: How do I clear the document?

The bigger idea is that I'm importing data from Excel to Word and I used to have my flow going basically like this:
Create Word application
Create Word document
Select the header
Edit the header
Select the "main part" of document
Type text
{


Paste a chart
Enter PageBreak
}(Repeat five times)
Paste a chart
Print to PDF
Close the document without saving
Terminate the instance of Word

With six charts, forty documents it took about three minutes. Now I realized that it's pretty stupid to create the Word application and Word document from scratch over and over again. Smarter solution would be just to delete everything from the document and close/terminate it at the end. Sure, I could also create a new document each time, but since I don't need the docs (the only reason I use Word at all is that it compiles the document nicely), I don't know if it would be any faster to create a new document.

If you know for sure that just closing the old and creating a new document is faster than deleting the whole content is faster, please tell me.

Even better might be linking system ie. I create the document by pasting once and then updating the charts in Excel updates them in Word and then I take a printout. Is that possible?

I tried that later part, just by pasting a link:

That first paste doesn't work, the next works fine. The error it gives is Run-time error '5342': The specified datatype is unavailable. Seems to me something is wrong with using that wdPasteMetafilePicture, but what?

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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.

Hi Jaymond,
Simple: put all the charts on the same worksheet, with page breaks between them.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Darn it with you experts, always ruining the hard work with some simplest possible answer

Thanks!