I want to close excel file in loop for each (item) before execute macro.
Main.xaml (14.3 KB)
- loop file in folder C:\Jess\Desktop\RPA\input\File
- keep path file in item
- keep sheet in item2
- write data item , item2 in file excel Reconcile Logic.xlsm
- run macro in file Reconcile Logic.xlsm
- go to step1 until loop in folder complete.
Please guide me about it.