469,611 Members | 1,690 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,611 developers. It's quick & easy.

VB.NET --> Excel --> Hyperion Essbase Plugin

Has anybody had the occasion to to build a VB.NET 2008 application that will
manipulate an Excel workbook including the Hyperion Essbase Plugin? I was not
sure which forum to post this question in so that is why I have chosen the
General.
If anybody has any ideas on the "Best" way to execute the "Retrieve"
function found on the Essbase plugin for Microsoft Excel located on the

xlApp.CommandBars("Worksheet Menu Bar").Controls.Item

One funny thing I have run into with trying to automate this via VB.NET is
that when my VB.NET application opens the Excel spreadsheet it somehow
appears to not contain the Hyperion Essbase plugin. When I open Excel
manually the Essbase plugin is plainly visible on the Worksheet Menu Bar.

This is also seen when executing the following:

Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(1).Caption.ToString()) '&File
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(2).Caption.ToString()) '&Edit
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(3).Caption.ToString()) '&View
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(4).Caption.ToString()) '&Insert
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(5).Caption.ToString()) 'F&ormat
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(6).Caption.ToString()) '&Tools
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(7).Caption.ToString()) '&Data
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(8).Caption.ToString()) 'A&ction
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(9).Caption.ToString()) '&Window
Debug.Print(xlApp.CommandBars("Worksheet Menu
Bar").Controls.Item(10).Caption.ToString()) '&Help

There is no instance of the plugin acknowledged while I can visibly see it
inbetween the Window & Help...

Anythoughts on how I can perform the "Retrieve" function from the Excel
Essbase plugin Worksheet Menu Bar menu via VB.NET or directions to the
apropriate discussion group would be appreciated.

Thanks to all

~ SPARKER ~

Jul 22 '08 #1
0 1363

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bryan Harrington | last post: by
2 posts views Thread by ExDelphi | last post: by
1 post views Thread by Jano | last post: by
2 posts views Thread by Gadi Refaeli | last post: by
10 posts views Thread by Mark Day | last post: by
6 posts views Thread by Joerg Battermann | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.