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
|