EXE. files

Posted by Lara on June 25, 2001 11:23 AM

I was wondering how to insert an EXE. file into an Excel document and have it open automatically when the Excel document is opened.

Posted by Ivan F Moala on June 25, 2001 2:03 PM

Insert / Object / create from file / browse
Then select your EXE file.

Start recording macro THEN double click the
inserted object (Activates it)
Stop recorder.

In workbook object Thisworkbook under;

Private Sub Workbook_Open()

End Sub

Reference your code to start here eg.

Private Sub Workbook_Open()
Macro1
End Sub

Ivan