View Single Post
  #5  
Old March 30th 06, 12:37 PM posted to microsoft.public.outlook.program_vba
FABIODIAS
external usenet poster
 
Posts: 1
Default VBA shortcut to open custom form in design mode?

Here My Friends,

Only 1 line !
CommandBars("Visual Basic").Controls(6).Execute

Regards,
Fabio Dias S.


"Burma Jones" wrote:

What I ended up doing is to use an AutoIT script to do a Sendkeys action:

Sub DesignCustomForm()

Dim RetVal

RetVal = Shell("""C:\Program Files\AutoIt3\AutoIt3.exe"" ""C:\DesignCustomForm.au3""")
SendKeys "%(tfe)"

End Sub

AutoIT script (DesignCustomForm.au3):

WinWaitActive("Design Form")
Opt("SendKeyDelay", 200)
Send("{DOWN}")
Send("{ENTER}")
Exit
"Burma Jones" wrote in message ...
There is a custom form that I modify frequently and I was wondering if there is any way to programmatically open the form in design mode? Currently I have to go Tools - Forms - Design a Form - Personal Forms Library - select the form (or double-click) - Open

Thanks

Ads
 

Loans - Myspace Layouts - Deaf Topics - Meeting Rooms - Web Advertising