how do I write code that will work with an add in

[Maui]

I am using an excel addin to a reporting software database named Adaytum, this is a windows application. . I have a drop down menu in excel that I just hit the menu, put in a password and then press refresh. I have tried recording this as a macro but when you look at the code there is none there. Is there anyway I can get code that will do this for me.

thanks in advance

Maui

 

[Andrew Poulsom]

You may get a clue by right clicking any ToolBar and choosing Customise. Then right click the menu item and choose Assign Macro. Make a note of the macro name and use Application.Run to run it.

 

[Maui]

I cant find adaytum drop down in customise so this isnt an option.

 

[Andrew Poulsom]

I cant find adaytum drop down in customise so this isnt an option.

You said "I have a drop down menu in excel that I just hit the menu". So can't you right click that on the actual menu (not in the Customize dialog)?

 

[Maui]

when I right click I get the toolbar options menu. where I vcan tick to see a toolbar or customise only.

 

[Maui]

ANYONE ELSE GOT ANY IDEAS.

 

[Andrew Poulsom]

First right click any Toolbar and choose Costomize to get the Customize dialog. While that is on the screen, left clicking a menu item will expand it (if possible) and right clicking will show a dropdown menu containing Assign Macro at the bottom.

 

[Maui]

Sorry

I got there now

I have tried running this

Sub adaytum()


Adaytum_CubeRefreshAll
Application.Run



End Sub


says Adaytum_CubeRefreshAll this is not defined

any ideas.

 

[Maui]

Application.Run ("Adaytum_cubeRefreshAll")


gort it working now.

do you know how to auto enter a password.

 

[Andrew Poulsom]

You may be able to use SendKeys for that.