Need Help in VBA Code

[Rohith1324]

Hi,

Currently one of the line in my code is :
bot.FindElementByXPath("//*[@id='createNewForm']/div[3]/div/div/div/ul/li[4]/a/span[1]").Click

the above highlighted value "4" should get replaced with the value from below specified formula :

c.Offset(0, 1).Value

So I have tried adding the above cell reference in the code as below , but not working :

bot.FindElementByXPath("//*[@id='createNewForm']/div[3]/div/div/div/ul/li" & c.Offset(0, 1).Value & "/a/span[1]").Click

can someone please help me in getting that incorporated in code please.

Regards,
Rohit

 

[snjpverma]

did you try removing the Quotes "" on both the sides?
like this:
& c.Offset(0, 1).Value &

instead of :
"& c.Offset(0, 1).Value & "