open work book
 

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

open work book
 

Nowfal:

'it must be named Workbook_Open; it must be housed in the ThisWorkbook module
Sub Workbook_Open()
Workbooks.Open ("C:\xxx\xxx\MicrPrint.xls")
End Sub

Elizabeth

"nowfal" wrote:


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

open work book
 

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

open work book
 

Hi,
thanks, one more question, if i want to close another workbook ho
it will be.


nowfa

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=39624