Making some very small progress. The code below does get the site to launch in a standalone IE app and sign onto the site properly, but does not seem to pass the cookies needed for Excel to perform a Refresh All on the web queries mapped in the workbook ... even after logging in and validating on the site, I get the 'web query returned no data' message when attempting to refresh. Therefore, I think the approach is to establish a link to pass the validated cookie from the IE app into the region that Excel is placing its cookies for web queries. Can someone help me with this? Thanks.
Sub LoginMe()
Dim appIE As Variant
Set appIE = CreateObject("InternetExplorer.Application")
appIE.Visible = True
While appIE.busy
DoEvents
Wend
appIE.navigate "https://www.hedgefundresearch.com/mon_register/index.php?fuse=login&1098991088"
Application.Wait Now + TimeValue("00:00:05")
AppActivate "HFRI Monthly Indices - Login"
SendKeys "{TAB 33}", True
SendKeys "superstar@excel.com", True
SendKeys "{TAB}", True
SendKeys "holla", True
SendKeys "{ENTER}", True
End Sub
p.s. I also used the SendKeys Method to launch a new query to the site and validate through the web query itself, but ran into the "Security Information - Page Contains Secure & Nonsecure Items ... Choose[Yes/No]" window at which point it seems that the Excel VAB macro loses control and cannot process anymore of the script. Any thoughts on how control can be readministered back to the VBA script and back to the New Web Query window where one come resume executing the new web query through the layered lines of the SendKeys Method?
Sub NewWebQueryThruSendKeys()
Application.SendKeys "%d", True
Application.SendKeys "d"
Application.SendKeys "w"
Application.SendKeys "{ENTER}"
Application.SendKeys "{TAB 4}", True
Application.SendKeys "https://www.hedgefundresearch.com/mon_register/index.php?fuse=login&1098991088", True
Application.SendKeys "{ENTER}", True
Application.SendKeys "{ENTER}", True
Application.Wait Now + TimeValue("00:00:03")
Application.SendKeys "Y", True
Application.SendKeys "{ESC}", True
End Sub
THANKS FOR THE HELP !!!!!