Situation:
There are multiple excel files. They all contain a unique code in their name:
Eg.: 10001, 10002, 10003,…
The files are stored on a different location
10001 - C:\Users\DelOli\Desktop\Folder\A
10002 - C:\Users\DelOli\Desktop\Folder\B
10003 - C:\Users\DelOli\Desktop\Folder\C
Problem:
There is a variable available that contains the unique code (10001, 10002 and 10003), but there is no data available that maps 10001 to A, 10002 to B and 10003 to C.
For the simplicity of this example I only used 3 folders, but in reality, there are a lot more folders.
Question:
Can I add wildcards to Excelscope?
For instance: C:\Users\DelOli\Desktop*[variable Unique code]
One solution(not the best) is if you have folder locations, you can run a for reach loop and check for “File Exists” and then add the file to excel scope.