ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print pdf from website (https://www.excelbanter.com/excel-programming/275597-print-pdf-website.html)

Murray Williams[_2_]

Print pdf from website
 
I found out how to print from a directory -- I'm using the
following code:

ShellExecute GetForegroundWindow, "Print", _
"C:\My PDF Directory/File1.pdf", _
"", "", SW_SHOWMINNOACTIVE

Now my question, how would I do something similar for
printing a pdf file from a website? When I try to use
something similar to that above, I get nothing:

ShellExecute GetForegroundWindow, "Print", _
"http://www.centman.com/PDF/ValueInvAug2003.pdf", _
"", "", SW_SHOWMINNOACTIVE

If I substiture "Open" for "Print" the ShellExecute code
will open the document:

ShellExecute GetForegroundWindow, "Open", _
"http://www.centman.com/PDF/ValueInvAug2003.pdf", _
"", "", SW_SHOWSHOWMINNOACTIVE

I got desperate so I then tried using sendkeys to print it
once it was open using the following:
"http://www.centman.com/PDF/ValueInvAug2003.pdf", _
"", "", SW_SHOWSHOW
SendKeys "%P", True 'Quit
SendKeys "{~}", True


I would be truly grateful for any help.

thanks, Murray Williams


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com