VBA automation to upload data into Salesforce

1.8k views Asked by At

The question is: is there any way to bind Excel with Salesforce and upload data? What I am looking for is a code to manipulate Salesforce from excel, that is, click a specified button (New Case), fill in specified fields with information from Excel cells and finally click another button (Save). Salesforce is opened from Internet Explorer. Does it mean it can be manipulated like IE object? If so, are they methods to navigate through specific fields on the screen?

Any directions very appreciated.

1

There are 1 answers

0
Tommeck37 On

Good example of how to connect to already running instance of IE is this:

Sub connectIE()
    Dim sWindows As New ShellWindows
    Dim IE As InternetExplorer
    
    For Each IE In sWindows
        IE.navigate ("https://en.wikipedia.org/wiki/Main_Page")
        'you can put whatever you want to do with IE here
    Do
    DoEvents
    Loop Until IE.readyState = 4
    

  
    Next
    
    
End Sub

please note you have to check the following items in menu>Tools>References:

'Microsoft Scripting Runtime' and 'Microsoft Internet Controls'