Essbase Disconnect

[ryDen]

Hi,

I'm trying to do some essbase retrieval for a certain workbook through vba. My problem here is that after retrieval has been done for each worksheet, the connection remains connected. There is this vba function "EssVDisconnect" which takes in a parameter sheetName. Would appreciate if someone could further explain in detail the syntax of this parameter,i.e., do we just input the worksheet name, or with the workbook name, and also how to use this function in code.

Thanks in advance.

Regards,
Russ

 

[Nelviticus]

I've never used EssBase but you may as well just try a few different options out. Pass it the string name of the sheet, pass it a worksheet object that refers to your sheet and so on. Eventually you'll find one that works.

Nelviticus