Hopefully someone can help me as I've been stuck on this for hours. I need to write macros for a number of functions in Excel VBA to access and manipulate SF data. I've had success using the sforce Connector addin via GUI but I now need to move to VBA. HOWEVER, everywhere I look online I see the step "add a reference to SFDCExcelAddin" and I can't figure out how to do this. I don't have SFDCExcelAddin in the Object Explorer. I do have "s_force" in the object explorer but it does not contain the same methods. Where is this located?? Thanks to anyone who is able to help!

Can you access the salesforce.com plug from VBA Macros? If so, what are the subroutine/function names in the project and what are their parameters...

I would like (from a macro):

1) Login to sfdc
2) Refresh ALL reports (or even use Refresh Selected Reports and select the reports by name)

Richard