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
chocoholicchocoholic 

Expanding Excel Connector functionality

I want to be able to develop an excel "application" that allows users to submit their timesheets to salesforce (i.e. complete the timesheet in excel and insert the data into salesforce), however  I need a lot more control around the data than what the excel connector provides.

 

Are there any means by which the code for the excel connector can be made available (e.g. licences), and if not, is there anything available that lists all the function calls within the excel connector so that I could call them from within my own code?

ScrapsScraps

You can view all the code for the Excel Connector in the VBA Editor - then it's just a matter of writing code in your processes to call the Connector functions.

 

Just started using office 2007 and you have to 'Show Developer Tab in the Ribbon' in Option / Popular to view the Editor 

chocoholicchocoholic
Thanks for that, but the version of the Excel Connector is password protected, so I am not able to see any of the code.  Is there a version that does not have the password?