Setting Excel filename as project variable

[nsievert]

Is there a way to set an Excel filename as a variable or something so if it changes name/location I can just update it once in one place?

I have a bunch of 'Excel- Read Value" operations in my keyword tests that point to an excel workbook on a network drive.  

They all point to different cells within that workbook but have the same file name. 

If the filename changes or moves, I would have to update each operation in every test instead of just updating one time.

Is this possible? 

[Marsha_R]

Sure! Make it as a string variable

myexcelvariable = "c:\myexceldirectory\myexcelworkbook.xls"

then choose that variable any place you need the file name

If you need to combine it with another string, you would use it in a code expression similar to this

 

[nsievert]

Hi Marsha,

When trying that, I am getting an exception saying file is not found.

See screenshots.

[Marsha_R]

If you hard code that same path into the test, does it work? 

[nsievert]

Yes it does. When I hardcode a path to a network drive or local drive path, it works.

[Marsha_R · Accepted solution]

Try it without the quotes around it in the variable value. You might not need those.

[nsievert]

That was seemingly it! Thank you!