Automate the saving of a PDF webpage using Access

[hardrock]

Hi all, Is it possible to automate the saving of a pdf in an open internet explorer webpage using Access Vba?


I am using.

Dim IE
Set IE = CreateObject("internetexplorer.application")
With IE
.Navigate http://mycompxxx.com/bin/portal_view_doc?DRAWING_NO=1234
Do Until IE.ReadyState = 4 'READYSTATE_COMPLETE

To fetch and open the PDF drawing from myworks server. This works, I just need to figure out how to save it to my harddisk now.

Thanks for any repsonse.

 

[DCrake]

If you have got to the stage where you can view the PDF document can you not just go to File > Save As... from the Reader menu, or am I missing something?

David

 

[hardrock]

yes you are missing something, but that's my fault. Please let me clarify.

Basically, i need to fire off 10 to 20 drawings off in sequence to separate supplier email addresses, and i want to get Access to do the work of fetching the drawing from the server (using a html link), saving the web page based pdf to the harddisk, attaching it to a new email and sending it off.

I have code already for the purpose of attaching and firing off the email, i just need some help sorting some vba code out that will fetch and automatically save the open pdf from the internet explorer webpage to my hard disk in sequence.

I hope this is a little clearer. thanks