I saved a couple of excel files inside a project folder. now I need to iterate through the folder to process each excel file. I want to put Use Excel File activity inside the For Each loop. is it feasible? if yes, for each activity or for each file in a folder, which is better?
Hi @haiyan.he,
You can use the two options, but if you use the Use Excel file activity inside of For each file in dolder activity posibly you don’t need to use so many activities. Try this configuration.
Cheers!
previously I inputted CurrentFile.FullName in the excel file path in Use Excel File activity, it has compilation error. after saw your reply, i tried again and it worked. it’s really weird. thank you guys. It really is appreciated for your help and let me feel not that frustrated.
thank you so much for your help. I like this forum and it makes my life easier a lot. Happy automation!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.