Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting VBE at EXCEL Start
Hi Don,
I'm trying to start Visual Basic Editor when EXCEL starts. This line shows the VBE: Application.VBE.MainWindow.Visible = True Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting VBE at EXCEL Start
If you are starting an application, then it probably has the focus and your
sendkeys goes to that application. Perhaps you want to do the send keys when you know that Excel will have the focus. -- Regards, Tom Ogilvy "Don" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting VBE at EXCEL Start
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
Starting Excel | New Users to Excel | |||
starting excel | New Users to Excel | |||
Starting Excel | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |