I have a list of Excel files and PDF files in an Excel workbook, and wrote a VBA macro to read from this list the path and filename and names of the sheets to be printed. I do want to print the files in the sequence as they appear in the list. However, that is now how it is send to the printed . As for instance, I read and print the data for a certain worksheet, next that of a PDF file, and thereafter that of another worksheet. However, the two worksheets are printed first and thereafter the PDF file exits from the printer.
The VBA macro prints the sheets through the Excel printout method, Excel being active of course. However, the PDF file is printed via an API call like
>> Set myShell = CreateObject("WScript.Shell") <<
>> myShell.Run ("AcroRd32.exe /t " & sFilename) <<
How can a force the printing order to follow that as given in the list?
Hope you can help me out. Many thanks ahead,