I have been looking for an answer but have had no luck. I have a macro that will build a URL address (intranet) to pull an xls file and copy the contents to original workbook which have the macro running. Everything worked great until my computer was upgraded to Win7 and IE8. The macro still tries to open the excel document from the URL but the macro never stops to wait for it to open instead it executes next line assuming the active workbook as the original workbook which started the macro. What am I missing here? Is any registry setting missing on my PC? It works on some other machine with Win7 & IE8.


ActiveWorkbook.FollowHyperlink _
Address:="http://www.knsn.com/protected-cgi-bin/ddts_query.cgi?", _
NewWindow:=False, AddHistory:=True

NumOfRows = Application.WorksheetFunction.CountA(Selection.Range("A2:A1000"))