xl instance

i want to work folow as after opening 2 xl instance, with
"controler.xls" control the "controled.xls".
for example, you must work follow as window startmenu -> run -> excel
->open ->controler.xls and window startmenu -> run -> excel ->open
->controled.xls.
and then the "controler" must handle the "controled".
i thank you very much if you show exampl macro source code.

please!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Does this work for you:

Put the following code inside of the THISWORKBOOK module of the file called
"Controler.xls" Change the path to fit the location of your Controled
file.

Private Sub Workbook_Open()
Workbooks.Open Filename:= _
"C:\Documents and Settings\UserName\My Documents\Controled.xls"
End Sub

"tom taol" wrote:

>
> i want to work folow as after opening 2 xl instance, with
> "controler.xls" control the "controled.xls".
> for example, you must work follow as window startmenu -> run -> excel
> ->open ->controler.xls and window startmenu -> run -> excel ->open
> ->controled.xls.
> and then the "controler" must handle the "controled".
> i thank you very much if you show exampl macro source code.
>
> please!!!
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>