Do you have access tot he page code? You will need to knwo where it submits to and what string it sends. You can then send that to the next page as part of a connection string.
or if you know the object name you can call it by making an IEObject.
Thanks for response Mark. Here is the code I wrote but I don't know how to bypass the security alert if using IE object, I can bypass by using MSXML2.ServerXMLHTTP object but don't know how to parse for a button and auto-click it.
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True
oIE.Navigate(strURL)
' loop until the page is loaded
While oIE.Busy
Wend
oIE.Document.All.Item("btnNTSSettings").Click
' loop until the page is loaded
While oIE.Busy
Wend
oIE.Document.All.Item("btnSyncNow").Click
While oIE.Busy
Wend
oIE.Quit
Set oIE = Nothing
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.