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 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. Internationalck1
then print workbook (X). worksheet (International)
next X
Else next X

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

hope that make sense.


--
Ryeno24
------------------------------------------------------------------------
Ryeno24's Profile: http://www.excelforum.com/member.php...o&userid=27915
View this thread: http://www.excelforum.com/showthread...hreadid=521658