Hi Folks

I recently installed an excel add-in application called
Essbase. I manually connect to a server that houses the
data for this add-in. This is done for every worksheet in
the workbook! Is there a way to automate this task via a
macro (such as a call function)?