Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Our new website | Setting up and Configuration of Excel | |||
Our new website | New Users to Excel | |||
Our new website | Excel Discussion (Misc queries) | |||
Our new website | Charts and Charting in Excel | |||
Website | Excel Discussion (Misc queries) |