Navigate in ie from excel using source code in web page

[chrisbrocco]

Hi all, i am trying to make excel open a web page then naviagte to a link. I know how to do this if the link has the same address all the time using

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
' Go to web page
.navigate "http://www.google.co.uk/imghp?hl=en&tab=wi"

Do Until .readyState = 4
DoEvents
Loop

but how could I navigate to a link which continually changes.

for example on a web page the link always shows "report", but the actual address may changes say every hour.

Is there a way to navigate to what ever address sits behind "report"

 

[chrisbrocco]

Thanks for all your help, I finally managed to do it my having a link to TestHtml.xls cell A1, then just opened and cloed the file, which inturn updated the the link.

then I just navigated to the linked cell.

cheers got there in the end :wink:

 

[MrMarlon]

I had the same problem, they couldn't help me here. Had to go to another more knowlegable forum.
This will take care of your problem:

' ie.Navigate "javascript
'=======================
Set o = ie.Document.all.tags("A")
M = o.Length: mySubmit = -1
For R = 0 To M - 1
If InStr(1, o.Item(R).innerHTML, "report", vbTextCompare) Then
o.Item(R).Focus
o.Item(R).Click: Exit For
End If
Next

Good Luck...

 

[Norie]

mrmarlon

Could you please explain how you didn't get any help here?

 

[MrMarlon]

I am only trying to learn, i am a hard working man.
I jus didn't get my question answer, I was even treated like a criminal...

http://www.vbaexpress.com/forum/showthread.php?t=11327&highlight=MrMarlon

 

[Norie]

You've lost me.

The first site you wanted to access was not no a secure site, agreed?

Then you wanted to access the FCC site, agreed?

Then you wanted to access the Sprint.com site?

As far as I know both of those sites are secure sites?

Who has called you a criminal?

If you are trying to access these sites then you might actually end up as as such.

 

[MrMarlon]

Correction:
The FCC is a public site, I navigate frequently to find out if our antennas are under regulations, anybody can run searches there. and Sprint ,is my company intranet wher I do all my work for the last 15 years

 

[Norie]

I give up.)

 

[NateO]

I had the same problem, they couldn't help me here. Had to go to another more knowlegable forum.

Hello,

No more posts to this thread, please! The issue is being handled here:

http://www.mrexcel.com/board2/viewtopic.php?t=255853

Remember, our rules indicate one thread per subject, duplicate threads are not allowed. Please do not respond to this post.

Our rules are important and we appreciate your following them! Thank you.