Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open all files in directory | Excel Discussion (Misc queries) | |||
search folder/directory for a phrase inside excel files | Excel Discussion (Misc queries) | |||
Unknown excel backup files created in network directory | Excel Discussion (Misc queries) | |||
Files in a directory? | Excel Discussion (Misc queries) | |||
Load all files in a directory | Excel Discussion (Misc queries) |