Hi Don,

Don schrieb:
I'm trying to start Visual Basic Editor when EXCEL starts.

I have an Add-In that has a workbook_Open macro:

Call Appl_Position
Call AddUtilities
Call InitArrays
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.getfile(FileSpec)
If Int(Now) Int(f.datelastmodified) Then start an appl
SendKeys "%{F11}"

It doesn't work most of the time.

Is there another way to do this.

try this:

Sub OpenVBEWindow()
With Application.VBE.MainWindow
.Visible = True
.SetFocus
End With
End Sub

--
Regards

Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)