@VJR
I tried using the VBA command to connect with a HFM database as described in the SmartView Developer guide (
here). I am able to get it to work in VBA just fine. I added the following in a code stage but received the following error
Description: Compiler error at line 3: 'System.Empty' is not accessible in this context because it is 'Friend'.
Here is the code stage:
Dim x as long
x = HypConnect(Empty ,"Username", "Password", "Connection_Name")
As you can see by the error it does not like 'Empty' in the first parameter for HypConnect.
I tried adding "Sheet1" in replace of 'Empty', however I receive this error message:
Description: Compiler error at line 3: Too many arguments to 'Public Sub HypConnect()'.
Please advise if you have any suggestions.
I wish BP would have more 'connectors' available. My guess is that there are many companies that are duplicating efforts in building common VBO's, such as SmartView.
Thanks!