Copy from closed WP selected in user from... help needed!

Hello!

I need help with copying from selected WB.

I have an userform which opens before code is run. In this userform, user have to select workbook which will represent data for prior year and it looks like this:

Please Login or Register  to view this content.

Now i have the whole path of selected file (including filename.xlsx) stated in label5 and need to copy some data from that workbook later in macro.
In example, i need to copy range ("F12:F17") from worksheet ("BIL") in selected workbook to range("E12:E17") in worksheet ("BIL") in workbook generated with macro.

I tried everything i could think of, but nothing worked. As i understand, i should be able to use both PYFPath and Label5 for this purpose, but i dont know how.
I also googled for "vba copy from closed WB" but neither of results had an example with reference to workbook selected in userform.

Please help.

thanks!

thank you for your answers.
@ buran: ADO is too complicated for me at this moment
@ John55 and NorieOpened: i would really like to keep workbook closed.

i know there is a simple way to copy from closed workbook:

Please Login or Register  to view this content.

but this way i have to type path, name and range into the code. I'd like to insert path from Label5 (which is path and name of selected workbook) into the code similar to one above.