opening a window via VBA
 

Anyone know how to open a 2nd workbook in VB? I also need it to close when
the original workbook closes

opening a window via VBA
 

You can use the auto_close() function in VB to close automatically the
workbook when you close the parent once. When do you want to open the 2nd
workbook ?

opening a window via VBA
 

i would like to open it when the parent opens

"preymond" wrote:

You can use the auto_close() function in VB to close automatically the
workbook when you close the parent once. When do you want to open the 2nd
workbook ?

opening a window via VBA
 

Please try Workbook_Open() and Workbook_BeforeClose events....

If this post helps click Yes
---------------
Jacob Skaria


"Lost" wrote:

i would like to open it when the parent opens

"preymond" wrote:

You can use the auto_close() function in VB to close automatically the
workbook when you close the parent once. When do you want to open the 2nd
workbook ?