How to use URL

hi
i have url that will have a combination of variable how can i put that in excel so the variable value get into that open browser activity

ex. “www.google.com/page”+Var.trim.tostring

var is variable that will contain a number

if i pass this in excel so it passing that directly in open browser activity

Hi @mint

Where are you getting the numbers that you are storing in a variable.

Regards

@Parvathy its a logic created from there it gets in

Hi @mint ,

Why do we need to store it in excel and read.?

If it is fine you can directly pass the URL to open browser na.?

Can you add what exactly are we trying to achieve here

Hi @mint

Can you please specify what are you exactly trying to achieve with help of some screenshots.

Regards

actually i am trying to make this dynamic i have 6 different URL as script is common so to make sure we can switch directly from excel i am trying to achieve that way so before execution URL can be selected as per change
@Parvathy @Gautham_Pattabiraman

@Parvathy i am just trying make sure that whatever URL is there in excel that should open but yes that might have a variable in it

Hi @mint

Can you tell where you are getting the numbers from into that variable.

Regards

yes basically if var is there that means its a number however its string type var

Hey @mint

just a suggestion, instead of making use of an excel, To make it dynamic why can’t you make use of Switch statetment.?

Thanks,
gautham

1 Like

yes i am using switch statement option only was looking if that is possible to do

Cool.! Hope you got it working.

Please mark the post that helped you as solution.

Else if you still want to know how to use via excel,

Use a config.xlsx file, Store the URL’s static parts. Read and initiate inside the solution. Dynamic number part to form a full URL and pass it on to open browser.

Thanks,
gautham.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.