open work book

[nowfal]

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

[Elizabeth]

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
>
>

[David Lloyd]

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" <nowfal.1tvi7p_1124222796.9345@excelforum-nospam.com> wrote in
message news:nowfal.1tvi7p_1124222796.9345@excelforum-nospam.com...

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

[nowfal]

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


nowfal