Skip Useforms for each sheet in activeworkbook

I need to skip/unload the userform for each read-only workbook (open other workbook to extract data - but contains with the userforms)

here the sample code

Please Login or Register  to view this content.

Userform appear from the "Filename" - Need to click on OK button to close.
There are 3 userforms in the read-only workbook where I need to get the data