I'm trying to create a macros that opens a proprietary URL in order to access a report that updates my spreadsheet. I managed to figure out how to open the URL from Excel but I need to figure out how to enter information in the URL (login, password, etc). Any ideas?
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Sub OpenURL()
Dim URL As String
URL = "entered URL here"
Call ShellExecute(0&, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus)
End Sub