Converting VBA to VB.NET

Thu, 05 Nov 2009 15:14:40 -0800

Hello All,

I am a newbie to Visual Studio and am looking to convert my VBA scripts to an Add-In. The first thing I need to do is create the custom toolbar.

In VBA:
Set MyBar = CommandBars("My Macros")
Debug.Print MyBar
If MyBar Is Nothing Then
Set MyBar = CommandBars.Add(Name:="My Macros", Position:=msoBarTop,
temporary:=False)
MyBar.Protection = msoBarNoCustomize
MyBar.Visible = True
End If

In Visual Studio using VB this is where my porting comes unstuck and where I need to be pointed in the right direction.

MyBar = CommandBars("My Macros")
If MyBar Is Nothing Then
CommandBars.Add(Name:="My Macros", Position:=MsoBarPosition.msoBarTop, Temporary:=False)
MyBar.Protection = MsoBarProtection.msoBarNoCustomize
MyBar.Visible = True
End If

The problem is with the use of "CommandBars". I have imported
Microsoft.VisualStudio.CommandBars. The context message I receive is:
'Reference to a non-shared member requires an object reference.' Everything else is good.

This has been buggin me for a couple of days. I've tried using
_CommandBars.CommandBars - nup; Application.CommandBars - nup; among other
attempts.

Any ideas, please?

Michael A.

Re: Converting VBA to VB.NET

Wed, 11 Nov 2009 07:55:07 -0800

I do not know anything about command bars... I couldn't find the namespace Microsoft.VisualStudio.CommandBars. I couldn't find anything on google in the few searches I tryed

If you can provide any examples of good CommandBar code in Vb.Net then I can assist you. Otherwise, you could try finding a new method to do what you want to do.

What was the function of the command bar in your old VBA program?

Sean Campbell

'Converting VBA to VB.NET' Thread RSS Feed

Converting VBA to VB.NET

Re: Converting VBA to VB.NET