Apex Code Development You need to sign in to do that
Don't have an account?
Kevin Kelly Change to API 7.0 using Office Developer Toolkit
I was trying to find info on this and could not find anything...so I am posting the solution that I was able to come up with.
By default, Office Toolkit uses API 6.0 and it is not necessary to set the URL that you are using. Changing to the 7.0 API is easy with the addition of one line of code. Not sure how long this URL will be valid. I found it by first logging in using the default and then wrote the Server URL of oSFDC_Session to the debug window. This gave me "https://na2-api.salesforce.com/services/Soap/c/6.0" and I simply replaced "6.0" with "7.0"
By default, Office Toolkit uses API 6.0 and it is not necessary to set the URL that you are using. Changing to the 7.0 API is easy with the addition of one line of code. Not sure how long this URL will be valid. I found it by first logging in using the default and then wrote the Server URL of oSFDC_Session to the debug window. This gave me "https://na2-api.salesforce.com/services/Soap/c/6.0" and I simply replaced "6.0" with "7.0"
'create a session object
Set oSFDC_Session = New SForceOfficeToolkitLib3.SForceSession3
oSFDC_Session.SetServerUrl "https://na2-api.salesforce.com/services/Soap/c/7.0"
Set oSFDC_Session = New SForceOfficeToolkitLib3.SForceSession3
oSFDC_Session.SetServerUrl "https://na2-api.salesforce.com/services/Soap/c/7.0"
'make a login call
oSFDC_Session.Login GetSFDCUserName, GetSFDCPassword
oSFDC_Session.Login GetSFDCUserName, GetSFDCPassword
the 7.0 endpoint also works with the Office Toolkit, but the toolkit has not had as much formal testing as was done with 6.0.
I've not heard of any issues, but just be aware of this difference and please report any issues you see.