function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jstemperjstemper 

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

ddddavoddddavo

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