This is a simple problem that I have:

I need to print (#) workbooks (already opened in excel)
each workbook has 2 sheet : "Domestic", "International"
I have to print "Domestic"wrksheet.
"Domestic"wrksheet has a link for income from the "International" worksheet.

If the amount for "international" on the "domestic" sheet is $0 then I don't have to print the "international" sheet.

==============================
Here's a rough VBA programming sketch (logic) I made.
I need someone to actually code it as I am a beginner to EXCEl VBA.

sub Batchprint

Wrkcount= (# of all workbooks open)
InternationalCk= this is the amount on the domestic sheet. The coloumn is absoulte , the row is not. it has to pick the value off to the right of the international text.

For x=1 to wrkcount
print. workbook (x). worksheet (Domestic.)
if workbook. active.worksheet. (domestic). cell. Internationalck>1
then print workbook (X). worksheet (International)
next X
Else next X

end batchprint
===================================
I know the logic just not the programming syntax.

hope that make sense.
thanks again