smartbutdull
IS-IT--Management
I want to write some vba scripts to run before I come into the office to open and update some spreadsheets which pull data from Essbase.
Does anyone know if it's possible to connect to the essbase source using vba without popping up a log-in screen?
I've found the following code to connect and retrive, but I still need to manually punch in the password:
X = EssMenuVConnect()
X = EssMenuVRetrieve()
Any ideas?
Thanks,
Phil
Does anyone know if it's possible to connect to the essbase source using vba without popping up a log-in screen?
I've found the following code to connect and retrive, but I still need to manually punch in the password:
X = EssMenuVConnect()
X = EssMenuVRetrieve()
Any ideas?
Thanks,
Phil