Changing value with selenium / VBA

Question

I tried to change value with below code but error occurred. Error message is 'sheet1 is not defined'. When i put text ex) "25-Sep-2020", it worked well.

Set ele = bot.FindElementByXPath("//tr//tr//tr//tr//tr//tr//tr//tr//tr[2]//td[2]//span[1]//span[1]//table[1]//tbody[1]//tr[1]//td[1]//span[1]//table[1]//tbody[1]//tr[1]//td[1]//input[1]")

attrScript = "arguments[0].setAttribute('value', sheet1.range ['B2'])"

bot.ExecuteScript attrScript, ele

Thank you in advcane.

baka_toroi · Accepted Answer · 2020-09-25 15:45:27Z

2

I'm not exactly sure what you're trying to do but it seems you're mixing Javascript code (not Java!) and calling it from VBA through the SeleniumBasic library.

You can't call sheet1.range from Javascript code. It won't know what to do with it. You need to unquote that part so it can be handled by VBA instead of by Javascript.

attrScript = "arguments[0].setAttribute('value', " & sheet1.range ['B2'] & ")"

answered Sep 25, 2020 at 15:45

baka_toroi

746 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Changing value with selenium / VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related