open a link on a webpage

[greeneyes]

can anyone give me the code to trigger a link on a webpage
example is it something along the lines of ie.document.(link).click

[6StringJazzer]

Your description isn't very precise; by "trigger a link on a web page" do you mean open a web page in a browser, if you have the URL? If that's what you mean, there is some code posted at

http://www.freevbcode.com/ShowCode.asp?ID=12

that does what I think you want. I have reproduced the code here. I have not tested it myself.

Please Login or Register  to view this content.

Let me know if I've misinterpreted your question.

[greeneyes]

Thanks for your reply. I apologies that my message isnt very precise but I can't post the webpage url as it contains employee confidential information. I have code that opens this webpage (URL) which has a username and password. The code passes the username & password to this page and logons on to another url. This URL has a number of Tabs (ie. Tab 1 is Employee Personal Details, Tab 2 is Employment Details etc) at the top of the webpage and to open this manually you can click on each tab the url address doesn't change when you move from 1 tab to the next. I want code that will allow me to open Tab 2 (Employment Details). I hope this is clear

[6StringJazzer]

That's a much better explanation, thanks. Excel can open a web page in a browser based on a URL, but if the URL doesn't change when you click different tabs on a page, then there is something else going on in the web application besides the browser just sending a URL page request. Either there are hidden variables, or some other type of client-side or server-side scripting or code.

If you can't type a URL into the browser to get exactly the page you want, then I am unaware of any method you can use with VBA to bring that page up. Someone else may know more.