Trouble I am finding there is I can’t find the file “workbook123” with a string search. I need to be able to read workbook123, workbook234, workbook*** or whatever the extension is from day to day.
I can easily put workbook123 into the use excel file>Excel file, but that pulls just that one workbook. I need it to be dynamic in pulling an excel file with a key word in it. The files are brand new every day and there is only one file with that “string”, so I won’t need to loop through every file. I can directly utilize the excel file from day to day, i just need to be able to ID the part of the file name so I can use that for specific use cases.
I tried creating a variable of a string for workbook*.xlsx but it comes up with the string error. I tried to do an object and that too failed. Maybe there is some other combination of using a variable for my dynamic file that will actually work.