Hello Everyone,
I know there is some information available on the web regarding my question, but I have been unable to figure out how to successfully update code snippets to satisfy my requirement and I think I may be missing something.
I have the following code within Excel:
Sub LoginStateStreet()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.Navigate "https://my.statestreet.com"
End With
Do While .ReadyState <> 4
Loop
'This is where I'm getting stuck. I would like to use VBA through Excel to review the HTML page of the web page to determine how to pass information from the spreadsheet to the web page. Viewing the page's source, I cannot seem to find controls associated with the web page form. Would anyone have any information on how to do this via Excel?
I certainly appreciate any information anyone may be able to offer.
I know there is some information available on the web regarding my question, but I have been unable to figure out how to successfully update code snippets to satisfy my requirement and I think I may be missing something.
I have the following code within Excel:
Sub LoginStateStreet()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.Navigate "https://my.statestreet.com"
End With
Do While .ReadyState <> 4
Loop
'This is where I'm getting stuck. I would like to use VBA through Excel to review the HTML page of the web page to determine how to pass information from the spreadsheet to the web page. Viewing the page's source, I cannot seem to find controls associated with the web page form. Would anyone have any information on how to do this via Excel?
I certainly appreciate any information anyone may be able to offer.