Skip to Content

Extended API available in Analysis 1.3

This document reviews the extended API available in Analysis 1.3 for analysis and components tab of design panel

 

The macro SAPExecuteCommand commands “Hide” and “Show” accept parameter TaskPane:

“Analysis” hides the tab Analysis in the task pane

 

“Components” hides the tab Components in the task pane

See this code below as an example:

 

Dim lResult As Long

lResult= Application.Run(“SAPExecuteCommand”, “Hide”, “TaskPane”, “Analysis”)

As an example, I insert a button under the Developer tab.

/wp-content/uploads/2013/01/1developerinsertbutton_171869.png

Enter the code as shown below:

/wp-content/uploads/2013/01/2vba_171870.png

Clicking the first button hides the Analysis panel.

/wp-content/uploads/2013/01/3hidesanalysispanel_171871.png

Clicking the second button will hide the components panel.

/wp-content/uploads/2013/01/4hidescomponent_171872.png

Clicking the last button shows all the panels

/wp-content/uploads/2013/01/5showsall_171873.png

Be the first to leave a comment
You must be Logged on to comment or reply to a post.