Reputation: 29
Is there a way I can connect to Salesforce.com through Excel Macro?
As we pull data from Oracle DB by creating a DB connect string, is it possible to do a similar setup for Salesforce too?
I am aware salesforce provides "Connect for Office" plugin but the problem with that plug in is it degrades the performance of Excel as it tries to connect to salesforce everytime you launch Excel.
Any thoughts will be appreciated.
Thanks
Upvotes: 0
Views: 5877
Reputation: 19040
You can use the Office Toolkit to write VBScript macros that connect to salesforce.
Upvotes: 1