You need to sign in to do that
Don't have an account?

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?
\TIA
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???