If you want to open a website and go through the results of a webpage using VBA
you can achieve it by first including a reference to Microsoft HTML Object Library
in your VBA editor.
The following snippet of code should be a good starting point of how you can achieve the same
|
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
I received the following error when trying to connect to a server's SQL Server. I was able to telnet the Server on the required TCP Port (1433) but SSMS could not connect to the SQL Server instance. Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was – [Pre-Login] initialization=13472; handshake=14425; (Microsoft SQL Server, Error: -2) I eventually found that a Hyper-V Adapter was responsible for the issue, disabling which resolved the issue, have faced a similar issue with VirtualBox adapter too. Hope it helps.
Hi Hitesh... what if you want to determine the final URL for the page?
ReplyDeleteHi Jon,
ReplyDeleteIn case the url is redirected you can wait for the required url /web page title to appear. Please have a look at this link for more help http://vba-corner.livejournal.com/4623.html. Let me know if this resolves your requirement