Hi Community
I'm not sure if I felt wrongly about this. I bulit a long excel flow involving different excels in different folders.
Method 1:
Step1: open a excel file and extract a datable using as EXCELINSTANCE 1
Step2: close the excel file and open multiple excel and update all as EXCELINSTANCE 2
Method 2:
Step1: open a excel file and extract a datable using as EXCELINSTANCE 1
Step2: close the excel file and open multiple excel and update all as EXCELINSTANCE 1
Both methods can run without error, but can also sometimes show errors.
I felt Method 2 gives errors more often. So i am guessing if it is better to have two instances, for different excel files that are not opened at the same time. (I read about the pros and cons of same/different EXCELINSTANCEs but what I experienced is not the same).
