edge browser control executejavascript method

Question

jsCode = "document.querySelector(""#form_arap_bxbusitem\&childform2 > div > div > div.vat_amount.js-type-number.form-item > div.form-item-control > div > span > div > div > div > div > input"").value = 8888"

me.edgebrowser.executejavascript(jscode)

executed successfully in chrome devtools console,but failed in vba

web page with frames

Answer 1

https://filetransfer.io/data-package/DoMYNUWt#link

thanks

用友的bip

Thanks for your feedback.

I have found two level iframes nested.

So in Access webview need grasp the element from the first level.

<script>

//<iframe id="forwardFrame" src="./新增_境内差旅费报销单_files/index.html" frameborder="0" height="100%" width="100%"></iframe>

///storage/emulated/0/Download/2/新增_境内差旅费报销单.html

//<iframe fieldid="main_iframe" id="mainiframe" class=" iframeIndex" frameborder="0" scrolling="0" src="./index(10).html" style="width: 100%; height: 100%;">

///storage/emulated/0/Download/2/新增_境内差旅费报销单_files/index.html

///storage/emulated/0/Download/2/新增_境内差旅费报销单_files/index(10).html

function myFunction() {

var elmnt = document.getElementById('forwardFrame'); 

 alert(elmnt.outerHTML)

var elmnt2 = elmnt.contentWindow.document.getElementsByTagName("iframe")[0];

 alert(elmnt2.outerHTML)

var elmnt3 = elmnt2.contentWindow.document.getElementsByTagName("input")[3];

elmnt3.value=888; 

}

// var elmnt3 = elmnt2.contentWindow.document.body;

 //alert(elmnt3.outerHTML)

/*

var elmnt = iframe.contentWindow.document.getElementsByTagName("input")[3]; 

alert(elmnt.outerHTML)

elmnt.value=888

*/

</script>

https://filetransfer.io/data-package/yS8d5EQq#link

js in VBA may like this.

jsCodes="var elmnt = document.getElementById('forwardFrame');

 alert(elmnt.outerHTML)

var elmnt2 = elmnt.contentWindow.document.getElementsByTagName(""iframe"")[0];

 alert(elmnt2.outerHTML)

var elmnt3 = elmnt2.contentWindow.document.getElementsByTagName(""input"")[3];

elmnt3.value=888; "

//单据日期

I have dissabled all css and js

Answer 2

floder 1 : open page

floder 1: after clicking add new bottun, show popup page

html file:https://1drv.ms/f/s!Am48J5c1efez5yY-yeuM5cP9s766?e=Sd6JfG

I have almost no js knowledge,so,it is complicated for me to resolove this problem.

i think best solution is waiting the opening of rest api.

thanks for you help!

Answer 3

https://microsoftedge.microsoft.com/addons/detail/tampermonkey/iikmkjmpaadaobahmlepeloendndfphd

Try tampermonkey.

Answer 4

Sorry,What did you mean failed?

No any detail?

Have you dumped the error message by error events?

Console only works in devtool.

So you need use alert to pop up error rather than console.

Have you tried below codes and not found any popup msgbox?

Try dump error.

jsCode = "window.addEventListener('error',function(e){

    alert(e.filename+'\nLine '+e.lineno+'\n'+e.message);

});"

me.edgebrowser.executejavascript(jscode)

jsCode ="document.querySelector(""#form_arap_bxbusitem\&childform2 > div > div > div.vat_amount.js-type-number.form-item > div.form-item-control > div > span > div > div > div > div > input"").value = 8888;"

me.edgebrowser.executejavascript(jscode)

//end

//this is another try

var iframe = document.getElementById('mainiframe');

var elmnt = iframe.contentWindow.document.getElementsByTagName("input")[3];

alert(elmnt.innerHTML)

//debug

elmnt.value=888

/*

the code above runed in devtools console forwardFrame successfully,but failed in vba executejavascript.

*/

if possible,share your source html.

jsCode ="document.querySelector(""#form_arap_bxbusitem\&childform2 > div > div > div.vat_amount.js-type-number.form-item > div.form-item-control > div > span > div > div > div > div > input"").value = 8888;"

var iframe = document.getElementById('mainiframe');

var elmnt = iframe.contentWindow.document.getElementsByTagName("input")[3];

form_arap_bxbusitem\&childform2 > div > div > div.vat_amount.js-type-number.form-item > div.form-item-control > div > span > div > div > div > div > input

just equal

elmnt?

How did you make

the code above runed in devtools console forwardFrame successfully?

What is forwardFrame?

Answer 5

var iframe = document.getElementById('mainiframe');

var elmnt = iframe.contentWindow.document.getElementsByTagName("input")[3];

elmnt.value=888

the code above runed in devtools console forwardFrame successfully,but failed in vba executejavascript.