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

I have a list of contact names in an Excel spreadsheet and want to use the Connector to check if these contacts are already in Salesforce.

I figured I could do this using the soql_table function. But instead of typing the name into the formula:
=soql_table("Contact","FirstName = 'Mike' and LastName = 'Stokey' ")
I was hoping to have the formula reference cells in the spreadsheet to find the names. I thought it would look like this:
=soql_table("Contact","FirstName = " & C3 & " and LastName = " & B3 & " ")
But that did not work. It gave me an error message: "unexpected token: Mike"

Can anyone tell me what I am doing wrong?

Thank you.