Print multiple hyperlinked pdf files from excel vba

[msriman]

I have a list of pdf files (hyperlinked) and I am trying to print them all when the user selects a 'print all' button. I do not want them to view the pdf document. They would just need to print them. I have also added individual command buttons that need to print each pdf document in the list or 'select some' from the list.
I have exhausted all methods. The Shell command works in opening the document but does not print. I would also like to bring up the print dialog box so the user can select their printer or options of duplex printing before the print job starts. (the printer dialog needs to come only once before the batch printing starts). I can do this for word documents (.doc) but not for pdf. All my users have pdf reader in their machines. Any help will be greatly appreciated. Thanks.

 

[SkipVought]

Hi,

Please repost this question in forum707, since this is VBA.

Please also post any relevant VBS code that you are using or are developing.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[vb5prgrmr]

Search the shell execute API... (ShellExecuteEx)



Good Luck