Hi everyone,

I create spreadsheets that are largely automated through VBA. The current problem I am having is the spreadsheets I am working on at the moment are linked to Sage through their Sage Integrated Add-In. Their Add-in has a drop down box to select which Sage application to look at, another to call a logon screen and a refresh feature to refresh the linked reports. Does anyone know how I could set these variables so that they can all be controlled through VBA.

I hope someone out there is able to use their expertise to be able to help me solve this issue.

Thanks in advance.