You can open the micrprint.xls in the Workbook open event of the micr.xls
workbook. You can access the Workbook open event from the "ThisWorkbook"
module.

For example:

Private Sub Workbook_Open()

Excel.Workbooks.Open("c:\micrprint.xls") 'Change to the correct
path here

End Sub

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"nowfal" wrote in
message ...

Hi,
I would like to know,how to open a workbook (micr
print.xls)automatically when i open a particular work book (micr.xls).
any code?
thanks
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=396241