Launch the vba editor from excel by code

Question

In Vsto-excel project , i have a macro in a particular module. By code in c#, i want to launch the VBA editor showing the given macro. i know the interop concepts , but i m stuck at launching the vba editor and showing the particular macro.

Francis Dean · Accepted Answer · 2012-10-03 10:08:10Z

5

You can use Application.Goto "MarcoName" which will open up the VBE at the sub / macro you specify.

answered Oct 3, 2012 at 10:08

Francis Dean

2,4962 gold badges23 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

KhannaB7 Over a year ago

yes that worked fine ,.... but if i am having 2 workbooks opened and both have the macro with same name ...then active workBook's macro is called ??

Community · Accepted Answer · 2017-05-23 11:43:12Z

0

The keyboard shortcut ALT + F11 on a open excel sheet ,opens the VBA Editor by default. Use the excel interop to open the excel and make the excel window visible .Then you can pass the keyboard shortcut to the excel window,from your application.

If you are using this on a winform application ,you can use the sendkeys method to pass the keyboard shortcut to the excel window. http://msdn.microsoft.com/en-us/library/system.windows.forms.sendkeys.send.aspx

otherwise use the sendmessage method to pass the keyboard shortcut across.Here is the so post on the sendmessage usage , c# Sending keyboard commands to another window / process.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Oct 3, 2012 at 5:46

Prabhu Murthy

9,2865 gold badges32 silver badges37 bronze badges

Collectives™ on Stack Overflow

Launch the vba editor from excel by code

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related