Could not parse Microsoft Excel version

Hi everyone!
I got an exception I haven’t found referenced:

System exception:
Could not parse Microsoft Excel version: $

Comment:
I cannot find a reference to this error, it seems a leak memory from Excel (0X00… like) but I get this error message instead. I solved it by going back to old guard methods :sweat_smile:

Workaround:
I happened when trying to open and close same excel file to get different sheets in a For Each loop.
Im Using Excel Scope, assigning Workbook variable and closing it after each extraction (Excel application scope, Read range, Colse Workbook)

Solution:
Right now, I’ve solved it by adding a delay of 2 seconds after Close Workbooc activity, I know it’s weird but it works.

I hope it can help someone, welcom anyone who wants to take the lead

Have a nice coding!

Hi @jmedinacarbonell try using workbook activities instead of application scope and things will work fine.

Hi and thanks for your help,
I forgot to tell it but, I had already tried this solution and … It throws errors, which seems normal since it has hidden sheets and Pivot Tables.
You can check this out : WorkBook Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index - #9 by pakankshabha
Only way to manage today I found is by the method described

I think yours is a good approach, I recommend to try yor solutions first and, if it doesn’t work, mine :slight_smile:

Cheers

Any chance you could create a sample fresh project that reproduces this issue for you 100% of the time? That would help a lot :slight_smile: