I am trying to call a JavaScript function through VBA - doesn't work

[nastyJ]

Hi all,

I am trying to click on a button present on a webpage using VBA, this button doesn't have any ID:

<a class="homeMenu" onclick="startBusyBox();this.style.cursor='wait' ;document.body.style.cursor='wait' ;" href="/CCCWeb/filterClientListFromDefineAsOf.do?do=clientMenu">

So I am trying to launch the function startBusyBox() like this:

Set IEDoc= IE.document
IEDoc.parentWindow.execScript ("startBusyBox()", "JavaScript")

But it doesn't work:

Run-time error '-2147352319 (800201001)":



Automation error

Anyone has any idea how to solve this??



Thank you very much

[excelliot]

Hi try this..

IEDoc.parentWindow.execScript "StartBusyBox()"

Cheers!!!

[nastyJ]

Hi try this..

IEDoc.parentWindow.execScript "StartBusyBox()"

Cheers!!!

Hi Excelliot, thank you for your answer but it's not working though, I have the same automation error

cheers

[excelliot]

hello can you share your whole code or url of webpage to which you arevtrying to access..

[nastyJ]

hello can you share your whole code or url of webpage to which you arevtrying to access..

Hello,

The webpage I am trying to access is an intranet page so you won't be able to see it unfortunately. This is the whole code of the page:

pageHtmlGce.jpg


Thank you

[excelliot]

can't read anything, attach in notepad..

[nastyJ]

imgur.com/KGoKV1T

Cheers

[excelliot]

it is clear now, can you expand that line & send me code for that...i want to see wahts in that...

[nastyJ]

Sure, I have expanded a few lines:

imgur.com/nHkWYuM

[excelliot]

Hi

do you have access to page "WWW/CCCWeb/filterClientListFromDefineAsOf.do?do=clientMenu"

Instead of WWW above add url of intranet on which you are running macro...

[nastyJ]

Yes I do, and actually I tried this and it worked.
But the issue is that sooner or later I will have to launch a JavaScript fonction. On the page /CCCWeb/filterClientListFromDefineAsOf.do?do=clientMenu, I have a droplist and when I click on it I have another JS function (changeSearchBy() ) as you can see in the screenshot enclosed. So basically almost everytime I want to click on a button or an option, it launches a JS function.
Thanks for your help!

imgur.com/Ml5ARlH