PDF Object Model in Excel 2007
 

Using VBA in Excel 2007 I download data for charting and also download
various reports in Word, Excel and Internet Explorer. Using the
various object models I can convert these (if necessary) to Word 2007
or Excel 2007 and then save them as PDF Documents. I can then print,
email and delete the PDFs as necessary.

I'm struggling to do the same with reports which are downloaded as PDF
documents already. I see that the references are available for
checking for Acrobat 8, Acrobat 7 and one other in Excel VBA tools-
references. I have Adobe Acrobat Reader 8 installed.

I'm sure if I can find a way to cycle (For Each) through a collection
of open PDF documents then I will be able to save them and then
print,email and delete them in code. I can't seem to find a suitable
collection in Object Browser.

Can anybody offer advice or links? Especially if I'm missing something
obvious
Thanks in advance.
Boxey