I wish they didn't take away the HypGetSheetInfo function. I hope I am missing something and it is really there and I am not seeing it for some reason.
There is a "partial" workaround, but will probably not work for me. The following code will populate the return parameters in the HypGetConnectionInfo function, but there are a few issues. In order for the HypGetConnectionInfo function to work, you must first make a call to HypGetSourceGrid. In order for HypGetSourceGrid to work, the focus must be in a "data" cell.
I am also not sure if this code will work after a connection has timed out. I don't think it will.
sts = HypGetSourceGrid(Empty, vtGrid)
sts = HypGetConnectionInfo(server, user, pwd, app, db, conn, url, provider)
My main goal is to try and get either the application name, cube name or friendly name for a sheet. I have built my own refresh button and I will use this info to automatically log a user back in if they are timed out when they click the custom refresh button. I would prefer not to manage the link between a sheet and its friendly name on my own. Hoping that there is some type of work around to the now missing HypGetSheetInfo function.
For any of the Oracle team members that may read this, any idea why that function was removed?
It is not a VB function and that is the reason why it is not there in the Developer Guide (that has all VB functions). Look in User guide and you'll find it. It is just like HsGetValue function.
Thanks for the clarification. Too bad there isn't a way to get that info with a VBA function.
You can get substitution variables using VBA, so I am surprised they did not offer the same functionality for sheet info. That would be very helpful in my case. Now I need to drop that formula into an empty cell on the sheet, evaluate the result, and clear the formula in that cell. Doesn't feel like the optimal approach.