VBA Runtime error 9 when closing opened workbook

Hello,
this is my 1st call for help in years. Usually i managed to find solution by searching WWW.
I have this SUB witch just opens file A, copy data to file B (to ThisWorkbook) and close file A.
When i made this Macro it worked well, but when I created UserForm and launch it from this Form it started to break here:

Please Login or Register  to view this content.

showing "Runtime error 9 Subscript out of range"

When Debugging conFileName holds files name as String.

The full code of Macros if it helps to understand:

Please Login or Register  to view this content.

I have more Macros very similar to this one (main changes: conFileName and ranges) and they are working like a charm!
Any ideas?

If you see that there may be any other modifications to this macro, please, Your suggestions are very welcome.
Thank you for reading all this!

perhaps

Please Login or Register  to view this content.

I reckon the [] in the file name were the problem-Excel won't let you save a workbook with those characters in the name