Ladies & Gents,

I'm trying to make a macro to do a few tasks, and have come to a halt as I
can't seem to find an answer to my questions. I hope someone can help me
out.

I want this macro to do the following;
1) - Create a work list
2) - Use that list to open datasets with similar names, and save them as
excel reports (2 off for each name in the list)
3) - Open those reports & create an invoice for each name in the list
4) - Combine those invoices & the first list into one workbook
5) - Print the invoices, &
6) - Email some of the reports (the remainder go by snail-mail!)

At this point in time, I have code to write most of the macro, but I have
the following questions;
A) - How can I use the list to open other files & spreadsheets? I can add
sheets to a workbook using that list, but I can't seem to find a way to use
the list to open new files.
B) - How do I send a page to print at a network printer, and to a particular
tray? I can find code on printing sheets, but none seem to deal with IP
addresses or printer trays. And,
C) - Can I run the macro with 2 other workbooks open at the same time? It
seems like I can create the invoice workbook if I have the macro going, open
up a report, and copy data to the invoice. But I've always been under the
impression that I can only have the macro & another workbook open at any one
time.

Any help with these questions would be greatly appreciated.


TIA
Andrew.