I recently received help setting up a file path as a variable string, see attached topic, but now I am having trouble accessing the file as the process begins.
I am using an Excel Application Scope to open an Excel file and while in the development phase, I had been using straight forward workbook path, for example: “H:\common\TRANSPORTATION\PROD Route Optimization\2018\10.29.2018\10.29.2018 Routing Guide RPA”. To the start the process, the excel application will open the file, then click on a specific tab labeled “Supplier.” From there the workflow will move back and forth from the Excel file to a Host Mainframe System. The data will be copied from the excel sheet then pasted into the mainframe system, updating specific parameters as defined in the Excel file. I have all of that set up, tested and ready to deploy, but I am needing to figure out how to enter the file path variable in the Excel application scope so that the file can be accessed.
Thank you as always for your help!