B
Boxey
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
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