Hi,
I was wondering if anyone knows how to select the "Refresh All Worksheets" for essbase worksheets in a workbook, which if done manually, would be found on the essbase tab's ribbon.
I'm aware that there's an add-in for specific essbase functions that would enable me to do this, however the workbook will be accessed by many different users and on different computers so is there a way to do it without the add-on as those vba functions mightn't work when they run the macro?
Alternatively is it possible to include in the code, a macro that will automatically seek the vba essbase add-in to download to their computer? They already have smartview and essbase however they wouldn't have the vba functions for it.
Each user's credentials would be different so all that is needed is for the initial "Refresh" to be ran, if a pop up looks for them to enter their password then that's fine.
Thanks very much in advance for any assistance!
Regards,
Eoghan
I was wondering if anyone knows how to select the "Refresh All Worksheets" for essbase worksheets in a workbook, which if done manually, would be found on the essbase tab's ribbon.
I'm aware that there's an add-in for specific essbase functions that would enable me to do this, however the workbook will be accessed by many different users and on different computers so is there a way to do it without the add-on as those vba functions mightn't work when they run the macro?
Alternatively is it possible to include in the code, a macro that will automatically seek the vba essbase add-in to download to their computer? They already have smartview and essbase however they wouldn't have the vba functions for it.
Each user's credentials would be different so all that is needed is for the initial "Refresh" to be ran, if a pop up looks for them to enter their password then that's fine.
Thanks very much in advance for any assistance!
Regards,
Eoghan
