Populate a userform listbox with data from another workbook that is closed

Hi folks, I have been trying to populate a userform listbox with data from another workbook that is closed, but no luck!

I have attached two files - Main and TheDatabase. I would like to achieve the below:

1. Open "Main.xlsb" file
2. Click Button1
3. Userform "frmViewRecords" opens and populates with data found in TheDatabase.xlxs file. To achieve this listbox population, I would like TheDatabase.xlxs file to be opened, populate the ListBox "lstRecords" from the Main.xlsb file and then TheDatabase.xlxs file should be closed without saving changes.
4. When I click on a line of data from the ListBox in Section A, I want that corresponding data to populate the associated TextBoxes of Section B.

Can you please assist? You can use whatever corresponding paths apply in your system for the location of TheDatabase.xlsx file when writing/testing the code, however we can assume that the path is C:\Users\ComputerName\Desktop\New folder\TheDatabase.xlsx

I don't want to use ADO.

Also, I tried online examples which did not work, such as the below:

Thanks!

Please Login or Register  to view this content.

LeoTaxi, thank you very much sir! That is some clever stuff, you make it so simple there.

What I should have mentioned in my original post, and very important, is the fact that both files cannot be in the same map. For example, the Main file will be in one server e.g. D:/Server1, and TheDatabase file will be in another server e.g. A:/Server2.

Therefore, is it possible to use your below code:

HTML Code: 

and combine it with the below code, so the path address can be entered to locate TheDatabase.xlsx file via the server address, open it, get the data and populate the listbox, and close TheDatabase file, just like the code below? I am not sure why the below code doesn't work for me. I tweaked it but it still leads to a debugging error.

Appreciated once again.

HTML Code: 

Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

exemple

Please Login or Register  to view this content.

Kind regards
Leo