A few folk have asked how to just connect automatically to Essbase from Excel VBA. Please find below a simple VBA sub stripped back to show this. Use the following to initialise with your own details in place.
Call initialise("xxx","xxx","xxx","xxx","xxx")