VBA - Using an Add-In menu that does not have VBA link

PDuPre' · May 23rd, 2002, 10:11 AM

We are using EssBase 5.02 revision 11 and from what research I have done there are no VBA links for this until version 6.5, which is just out or will be coming out.
I want to have VBA use the menu commands from the EssBase menu, but when I do a record-macro it can not record those entries.
-------------------
Is there a way to program in VBA the same effect as on the keyboard? Essentially feed a CTRL-S into the program. If I do this manually it will pull down the EssBase menu. Afterwards I would press 'R' to perform a Retrieve from the EssBase database.
I guess it is not possible, but this board's knowledge of Excel and VBA has surprised me in the past.

Thanks,
Philip

Russell Hauf · May 23rd, 2002, 10:13 AM

Yes, it should be possible. Look up the SendKeys function in VBA help.

PDuPre' · May 23rd, 2002, 10:31 AM

I'm glad it was so simple. Always amazed.
I got my button created and it works fine. Novice users will like the new functionality a lot.

Thank-you very much.

Philip

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 10:11 AM	#1
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	We are using EssBase 5.02 revision 11 and from what research I have done there are no VBA links for this until version 6.5, which is just out or will be coming out. I want to have VBA use the menu commands from the EssBase menu, but when I do a record-macro it can not record those entries. ------------------- Is there a way to program in VBA the same effect as on the keyboard? Essentially feed a CTRL-S into the program. If I do this manually it will pull down the EssBase menu. Afterwards I would press 'R' to perform a Retrieve from the EssBase database. I guess it is not possible, but this board's knowledge of Excel and VBA has surprised me in the past. Thanks, Philip

May 23rd, 2002, 10:13 AM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Yes, it should be possible. Look up the SendKeys function in VBA help.

May 23rd, 2002, 10:31 AM	#3
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	I'm glad it was so simple. Always amazed. I got my button created and it works fine. Novice users will like the new functionality a lot. Thank-you very much. Philip