Nightlytic
Member
Hi All,
I have some need for an explanation of how VBA I use daily works. This is a very old system from SAP, a VBA plugin.
within the code, it creates an object:
Set pAddin = CreateObject("com.sap.bi.et.analyzer.addin.BExConnect")
I gotta say I'm very confused by that line above, especially the com.sap.bi.et.analyzer.addin.BExConnect, what is this? is this a file? website?
Can I open this???? how?
Then, depending on what menu button is clicked, some subs would say something like:
Dim lCMD As String
lCMD = pAddin.ExcelInterface.cCMDToggleDesignMode
Call pAddin.ExcelInterface.ProcessBExMenuCommand(lCMD)
AKA, on the last line it looks like there is a vba project called pAddin but there isn't one on the VBA project explorer.... Presuming Excelinterface and processbexmenucommand are macros and a sub respectively. Am I correct on that?
Ultimately, I want to see the code going on behind that pAddin, what happens to the CMD once I pass it. What could this paddin be and how I can open it. Ideally I'd ask SAP but this stuff is like 30 years old, and I suppose they don't want people to see the code... but I only need to know where my workbooks base their data out of and that's hidden...
Thanks!
I have some need for an explanation of how VBA I use daily works. This is a very old system from SAP, a VBA plugin.
within the code, it creates an object:
Set pAddin = CreateObject("com.sap.bi.et.analyzer.addin.BExConnect")
I gotta say I'm very confused by that line above, especially the com.sap.bi.et.analyzer.addin.BExConnect, what is this? is this a file? website?
Can I open this???? how?
Then, depending on what menu button is clicked, some subs would say something like:
Dim lCMD As String
lCMD = pAddin.ExcelInterface.cCMDToggleDesignMode
Call pAddin.ExcelInterface.ProcessBExMenuCommand(lCMD)
AKA, on the last line it looks like there is a vba project called pAddin but there isn't one on the VBA project explorer.... Presuming Excelinterface and processbexmenucommand are macros and a sub respectively. Am I correct on that?
Ultimately, I want to see the code going on behind that pAddin, what happens to the CMD once I pass it. What could this paddin be and how I can open it. Ideally I'd ask SAP but this stuff is like 30 years old, and I suppose they don't want people to see the code... but I only need to know where my workbooks base their data out of and that's hidden...
Thanks!