Can't use DescribeSObjects in SF Office Toolkit 4.0
I am attempting to use the DescribeSOBjects using the office toolkit vs. 4.0, and cannot seem to get this to work properly.
Does anyone have some good examples of how to use this method in the VBA editor?
Private Sub GetSObjects_Click()
Dim Username As String
Dim Password As String
Username = "email@example.com"
Password = "password"
Dim sfSession As SForceSession4
Set sfSession = New SForceSession4
Dim dsr() As String
If sfSession.Login(Username, Password) Then
dsr = sfSession.DescribeSObjects( "Account")
MsgBox "Invalid Login"
When I run the above line I get an error saying Expected Function or Variable
Even when I change dsr = sfSession.DescribeSObjects( "Account") to
I still get an error saying: Array passed to DescribeSObject needs to be of type VT_BSTR or BT_VARIANT.
Any help would be appreciated.