Printing .pdf files from directory from excel
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_SHOWMINNOACTIVE
I would be truly grateful for any help.
thanks, Murray Williams
-----Original Message-----
I have a spreadsheet that has links to cells that refer
to
specific .pdf report files. I'd like to be able to set
it
up so that a user could select several cells and then hit
a button that would print the .pdf files for those
selected cells by clicking on a "Print Selected PDF
Files"
button.
For example, let's say I had a directory called == C:\My
PDF Directory and it contains the following files:
File1.pdf
File2.pdf
File3.pdf
File4.pdf
File5.pdf
How would I issue a command from excel to print files 2,4
and 5 if those were the ones that were selected?
thanks,
Murray Williams
.
|