VBA Function for XFDF import into Excel very slow

I found a VBA function that parses Adobe PDF Form XML data (.xfdf) into an Excel worksheet. When this code is used in a separate Workbook without anything else it works fast (<1 sec). However when I use it in the large workbook that I use to generate individual PDF reports it's extremely slow (~5 minutes!!)

I've tried adding Application.ScreenUpdating = False, Application.EnableEvents = False, Application.Calculation = xlCalculationManual and Application.Volatile (False), but it didn't help.

Any ideas are very welcome. (I'm a VBA beginner, able to copy and adapt scripts I find for my purposes...)

This is the code used:

Formula:

Please Login or Register  to view this content.