+ Start a Discussion

Excel Connector and QueryAll

I can successfully connect to and query data via the Excel connector. Now I am trying to pull archived data from Task and Event. Is it possible to QueryAll and not just Query via the connector?


Any suggestions onhow todo this?




I have a similar need--looking at archived Tasks using the Excel connector.


When I find the query_draw function where the current connector does its work...well, the vba blows up as soon as you try to run a query based on the salesforce.QueryAll(select...) statement.  Error message is "method or data member not found."


I've used this statement successfully in other VBA modules I've written, so I know it works...but there's something missing from the excel connector (even though it's using sObject4 libraries).


don't get it...ideas???