excel add-in in 2003

[krishhi]

Hello guys,

I have a question. I was successful in making excel add-ins in 2007, But i have a problem with excel 2003. what i want is, that excel add-in should shows under add-in tab. ya, i want it in excel 2003 and 2007 both version.

I found some of the add-ins are shown under the add-in tabs. How to do that?

thanks,

Krrish :friends:

[GTO]

In the add-ins dialog, click Browse and find your add-in. It should show up in the dialog then.

[krishhi]

In the add-ins dialog, click Browse and find your add-in. It should show up in the dialog then.

Hey,
Thanks for the quick reply, i got in 2003 but in 2007 it doesn't show anything otherwise shows in vba environment.


here is a simple example:

i have a macro like



sub test()
dim n as string
n = inputbox("Enter Your Name")
range("a1").value = n
end sub

I saved this file as add-in,
How do i show this under add-in tab?
Any Clue?

[GTO]

Hi Krrish,

Sorry, I thought you were asking about 2003. I do not have 2007, so cannot help:(

Mark

[Bob Phillips]

I think you need to be clearer.

Is the problem in 2007 or 2003?

Where aand what are you expecting to see?

[krishhi]

I think you need to be clearer.

Is the problem in 2007 or 2003?

Where aand what are you expecting to see?

Hey,

Sorry for the Confusion

I want to show an new add-in under the add-in Tab in 2007.

[Bob Phillips]

You need to have some commandbars for it to show there.

[krishhi]

You need to have some commandbars for it to show there.

how to do that? Any Examples or references?

[Bob Phillips]

If you don't have any commandbars already, why do you want it to appear in the addins tab? What does your addin do?

[krishhi]

If you don't have any commandbars already, why do you want it to appear in the addins tab? What does your addin do?


????????

I told you, I want to create a new add-in under Add-ins Tab in 2007. That's what i am asking how do i insert or create a new add-in.

[Bob Phillips]

You don't understand. The addin does not appear in the addins tab just because it exists, any 2003 commandbars that the addin has will appear in the addin s tab in 2007, not as a toolbar or menu as it does it 2003.

[geekgirlau]

Essentially if you have created a custom toolbar in 2003, it appears under the addins tab when you open that file in 2007. However there is no simple method of adding a new button directly to the addin tab in 2007.

Short answer: you need to have a different approach for 2007.