VBA - Click Javascript-based Anchor?

[t3chie]

Windows OS - Win7
Excel Ver. - 2007
IE Ver. - 8

I'm attempting to setup an excel based automation of pulling a report, however to access the report. I need to navigate a javascript based link, it has no ID or name so my usual code doesn't work.

<'a href='javascript:parent.AdminJS.resetDoCmd();parent.AdminJS.setContentsUrl("javascript%3Aparent.AdminJS.setContentsUrl%28%27/webview/FavoritesFrame.jsp%27%29%3B");'><'script>document.write(properUnescape("Favorites"));<'/script>Favorites<'/span><'/a>

I can't figure out a way to execute this script or click the link itself, it has to be a click or javascript execution because it manipulates the HTML on the page and cannot be navigated to directly.

 

[rwhitmore90]

t3chie, have you figured out a solution? I'm in the same boat I can't post the source code because it is internal. The website from what I can tell is just a series of javascript functions. The URL to the page does not change after login.

Any advice would be great.

 

[t3chie]

t3chie, have you figured out a solution? I'm in the same boat I can't post the source code because it is internal. The website from what I can tell is just a series of javascript functions. The URL to the page does not change after login.

Any advice would be great.

Hi,

Unfortunately, I never did figure this out. Luckily, we ended up upgrading our system, which moved away from the old deplorable web interface I was attempting to navigate in VBA. Best of luck to you rwhitmore90.

 

[rwhitmore90]

Hi,

Unfortunately, I never did figure this out. Luckily, we ended up upgrading our system, which moved away from the old deplorable web interface I was attempting to navigate in VBA. Best of luck to you rwhitmore90.

I know it seems like I'm giving up soon but after spending 4 hours looking through it today the amount of time this project would take is not worth the cost. Hopefully I will get lucky and they will upgrade the system.