Excel VBA Macro to Open A Node in SAP SPRO IMG tree

[plwhittington]

I am using a macro in an Excel Workbook to try to export values from the SAP IMG to compare some settings. My macro can get to the IMG via the SPRO t-code, but I want to be able to select and expand certain nodes. I know the path/name of the nodes, but I do not know how to expand and select. (I can perform a "Find" on the bottom node, but still not sure how to select it to display the values)

The SAP GUI script records the following lines when I manually use the mouse to select nodes ("Cross-Application Components" and then "Master Data Synchronization"), but I don't know how to find a node using code and expand it, then select the node underneath "Master Data Synchronization" that I want to view/edit.

session.findById("wnd[0]").maximize
session.findById("wnd[0]/usr/cntlTREE_CONTROL_CONTAINER/shellcont/shell").expandNode "02 1 5"
session.findById("wnd[0]/usr/cntlTREE_CONTROL_CONTAINER/shellcont/shell").topNode = "01 1 1"
session.findById("wnd[0]/usr/cntlTREE_CONTROL_CONTAINER/shellcont/shell").expandNode "03 2 29"
session.findById("wnd[0]/usr/cntlTREE_CONTROL_CONTAINER/shellcont/shell").topNode = "02 1 5"


Any help would be appreciated. Thanks.