doesn't anyone here know IE controls?

[thomas donino]

I have posted this on so many boards I am shocked that noone has an answer.
I have a macro running in excel 2007 that opens many pdf's from different
webpages and saves them. I have no problem navigating around IE through vba,
BUT how can I control printing via the IE window when a pdf is opened INSIDE
the IE window. I would be happy to post a screenshot of the window a) if
thats allowed and b) if someone describes how to do so.

Help!!

thank you

 

[Patrick Molloy]

I dont' know how you'd do this. I'd suggest maybe useing SENDKEY ?

 

[thomas donino]

Sendkey is to unreliable. There must be IE controls that allow selecting and
manipulating printers

 

[p45cal]

Post the code you currently use for 'navigating around IE through vba'.
I'd be surprised if IE doesn't expose its objects.
What version of IE?
I had some trouble, but succeeded in the end, with establishing the
right printer to print pdf files to for any machine on a largish company
network, but it depended on which version of Acrobat was installed (and
some of the Adobe object maodel manuals were plain wrong).
I'd guess that you'd have to go through a similar (and simpler) process
with IE with a pdf in an IE window.

 

[Matthew Herbert]

Thomas,

See my previous post in your "testing url string" subject line post (thread
link below) and let me know if that does the trick.

Best,

Matthew Herbert

http://www.microsoft.com/communitie...ming&mid=6e74aa31-0321-4431-878d-b69d6540aa52

Open a pdf that opens in explorer from any website. its the same thesis, a
pdf thats open in explorer. I perused the site in question but i dont see any
free pdf's to download.

 

[p45cal]

Open a pdf that opens in explorer from any website. its the same thesis
a
pdf thats open in explorer. I perused the site in question but i don
see any
free pdf's to download.

OK. Clearly I can't get to the same pdf files, nor to the page they [snipped]

Many of the techniques to gain access to objects required to contro
printing of pdf files require the full version of Acrobat Reader to b
installed. Then it would be easy but.. my machines don't. However, no
one to give up easily:

Do you have the full Acrobat reader installed, or just the fre
reader?
Is this just for you or for a whole raft of users on differen
machines?
Do you have -any -*full *Adobe pdf programmes installed