Overview: I have taken on a new project to automate the creation of
production books used out on the floor. These production books contain
machining instructions, blue prints, palletize information, order detail, etc.

Question1: I am creating a workbook in which I would like it to open up many
..xls and a few .doc documents and run the procedures contained in these files
in the background. These files are automated for there specific task but
require the user to enter an order number and select a few settings from a
form attached to the workbook_open event. What is the best way to go about
passing the order number and preference variables to these without the form
being displayed for each file. I would like to keep the forms in the
workbook_open event so that they can run each task individualy if needed. Any
suggestions greatly appreciated

Question2: In the production book creator workbook I have a settings
worksheet where I allow the user to change file name, path and print order of
the files listed above. I got everything working fine for the file paths but
I am having trouble with the print order settings and how to create a
procedure to prioritize the call of other procedures.

Question3: Can the printing message box be disabled when a document prints
as I would like this to run completly in the background and inform the user
on the main form any print errors and so forth.

Question4: Could anyone point me in the direction to automate the printing
of drawings from Inventor View and Autodesk DWG Viewer.

Sorry for the long post...
Thanks for your time it is greatly appreciated!!