Forum Discussion

nastester's avatar
nastester
Regular Contributor
3 years ago
Solved

Setting Excel filename as project variable

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 ke...
nastester's avatar
nastester
Regular Contributor
3 years ago

Hi Marsha,

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

See screenshots.

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
3 years ago

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

  • nastester's avatar
    nastester
    Regular Contributor
    3 years ago

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

    • Marsha_R's avatar
      Marsha_R
      Icon for Champion Level 3 rankChampion Level 3
      3 years ago

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

      • nastester's avatar
        nastester
        Regular Contributor
        3 years ago

        That was seemingly it! Thank you!