title: How can I automate PeopleSoft using Excel VBA?
body: <p>I have a list of people and their emails in a spread sheet and I need to enter their emails into their account on People Soft V8. There is thousands of them so I was looking to automate this process.</p>
  
  <p>I have started with the following code, but have been getting</p>
  
  <p>run time error<br>
  Automation error 
  Unspecified error </p>
  
  <pre><code>Sub GoToWebSiteUpdate()
  Dim appIE As InternetExplorer
  Dim sURL As String
  Dim UserN As Variant
  Dim myLoginID As String
  
  Set appIE = New InternetExplorer
  sURL = "Webaddress"
  appIE.navigate sURL
  appIE.Visible = True
  
       'Enter information in the first drop down
      Set UserN = appIE.document.getElementsById("InputBox")
      UserN(0).Value = "012354"
  
  
  Set appIE = Nothing
  End Sub
  </code></pre>
  
  <p>If anyone has any ideas that would be great, Thanks.</p>