Hi kleinma,
I've been successfully using your example here to pull a listing of hyperlinks off one of my Intranet pages for a basic listing of links.
Well i have like 100 web pages i would like to run the program on. However because .net cycles through the pages so fast, i don't think the pages are fully loading, and it just repeats the hyperlinks from the first web page 100 times.
Do you know if there is a way to execute some code once the page is fully re-freshed? So cycle through each ".htm" file, and once its finished totally loading, then run the hyperlink code. The code then pastes it into an excel sheet. Which i have working. Just not the wait for page load type thing?
Any ideas? Thank you for any help!!
So im using
Code:Strpath = "\\server\Intranet\Intranet\CAD Dept" For Each strdir In IO.Directory.GetFiles(Strpath, "*.htm", IO.SearchOption.TopDirectoryOnly) wb.Navigate(strdir) For Each MyLink As mshtml.HTMLAnchorElement In GetCurrentWebDoc.links Temp &= MyLink.href Wksht.Cells(MyrowNum, 8) = Temp i += 1 MyrowNum = MyrowNum + 1 Temp = "" Next Next




Reply With Quote