I have n Excel-Files on a certain folder which I would like to open each by each and extract data to a variable.
All Excel-Files have the same amount of columns and I would like to open the first Excel-File, put the data of a static cell into a variable and afterwards use this variable to search something in SAP.
I’m fine with the SAP steps, just struggling to loop through the folder, open the first Excel-File, get the number of the cell A1 there and then use this number. Afterwards to the same process for the 2nd file.
I’m thankful for every hint!
Best answer by Abhay NaikView original