Hi all,

I have added the line Dim oWBAudit as Object and the program now works
but is trying to open the tracking workbook twice and then the code
breaks with a "Method of workbook open failed"

Any refinements to cure this?
I would prefer for the tracking workbook not to open but if this has to
be the case could it save and close straight away?

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=266360