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
|
The following VBA procedure can be used to apply borders to a range of cells Public Sub ApplyBorder(ToRange As Range, intColorIndex As Integer) On Error Resume Next With ToRange With .Borders(xlDiagonalDown) .LineStyle = xlNone End With With .Borders(xlDiagonalUp) .LineStyle = xlNone End With With .Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin ...
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