Fire Excel Macro Only IF Specific URL Change, Exit Sub IF Not This URL

Fire Macro Only IF Specific URL Address Change Is Requested From WebBrowser Object?

I am using a WebBrowser Sub that runs a macro when the URL Address changes.

The problem is it fires the macro each time the browser is refreshed because it changes (or refreshes back to itself and runs the macro).

I would like the macro only to run ONLY when a SPECIFIED URL is requested.



The code beneath works great.
All are welcome to try this code for yourself (click on the developer tab>insert tools>more tools>microsoft web browser>draw browser>paste code beneath in vba)

Please Login or Register  to view this content.

The only problem is (as stated above), it launches each time the page is opened or refreshed. I am in need of a way to code this the right way so that it only runs the macro if a specified URL address is requested only. This way the macro will not fire up at start up or when the page is refreshed, but yet only when the specified page is loaded with the web browser.

Please Login or Register  to view this content.

cross post link: http://www.dbforums.com/microsoft-ex...ml#post6483450
Can anyone help me with the correct working syntax for this code?

also cross posted at MrExcel - with links to others:

http://www.mrexcel.com/forum/showthread.php?t=505461

In terms of why we ask you to detail all of the cross posts: http://www.excelguru.ca/node/7

It is not my intention to mislead or confuse, I do enough of that to myself when it comes to this stuff : )

Originally Posted by indi visual

I honestly didn't know that developers check other forums as well.

Sincerity aside the above is wholly irrelevant.

People contribute their own spare time free of charge.

By cross posting and not providing all links you are increasing the likelihood that those same people are wasting their time* - time that could have been spent helping others
*resolving a problem which unbeknownst to them has been resolved elsewhere

Put simply we ask you do not abuse the good nature of those trying to assist you - thank you for providing all the links above.

Well I note you have had some assistance on your XVBT - I would suggest you persevere with that thread.
You will be hard pushed to find someone better able to assist you than Colin Legg - however many forums you post the question to.