By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,694 Members | 1,882 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,694 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.