The process cannot access the file because it is being used by another process

[beesheep (Eduardo Bernabe Sacahui Diaz)]

Hello and thank you for your inquiry.

first of all I guess you need to redefine the process because you are trying to get information from an excel template while it’s being process…(obviiously the reason for the error XD)

So, I see two approcheas here, one is to save the workbook and continue or to ask the user to close it. Like I said you need to define your automation in the way that will achieve what your customer wants to achieve.

For the ones intriguing about System.GC this and this article might be helpful

and here it’s the XAML xlalreadyopen.zip (51.2 KB)