function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Carli AndersonCarli Anderson 

SForce Excel Connector Access via VBA Macro

I created a macro in Excel that updates a custom object each month. It does everything except use the connector to: refresh the page, update the changes, and delete certain items, this has to be done manually by me after the macro finishes making the updates. I've tried researching this, but the only thing I've found doesn't work for me. Found here (https://developer.salesforce.com/forums/ForumsMain?id=906F00000008rkhIAA).

I basically need the macro to access the connector plugin to refresh a query, update certain fields, and delete certain objects.

Thanks.
RamuRamu (Salesforce Developers) 
The below post might help

https://developer.salesforce.com/forums/ForumsMain?id=906F00000009CiBIAU
Carli AndersonCarli Anderson
I've added the plugin as a reference, but I don't know the code for the addin's public functions. Is there a list of those public functions, in code, for the connector? Or if you know the code for Update Selected Cells, Insert Selected Cells, Delete Objects, and Query Table Data?

Thanks.