search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2k stars 494 forks source link

Salesforce Example #245

Closed nitinsolanki closed 8 years ago

nitinsolanki commented 8 years ago

Hi Tim,

I am trying to use the Salesforce Example. I have entered the Consumer Key, Username, Type (Account) and Id (ObjectID). I am getting the following:

Error 13: Type mismatch

Do I need to enter the password or consumer secret key? If so, where do I enter that information.

Thanks

timhall commented 8 years ago

Hi @nitinsolanki, your security token (should be emailed when you set/change your password) and consumer secret is required, but it should prompt you to enter it. You could also create a credentials.txt in the root of the VBA-Web project (of the unzipped release), based on credentials-example.txt that includes the username, security token, key, and secret.

Other than that, I'm not sure what exactly could be causing the Type mismatch, if you can debug the program and let me know where the error is occuring, I can help further (here are some great tips: http://www.fmsinc.com/tpapers/vbacode/Debug.asp)