View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don[_15_] Don[_15_] is offline
external usenet poster
 
Posts: 1
Default Starting VBE at EXCEL Start

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.

Thanks,
Don