Get value from workbook closed

[slamet Harto]

Dear Master,

I have a problem with the "user form" to look up and get the value from excel file (which are closed and saved in a different folder/drive)


What I needed is when we choose ComboBox1 and ComboBox2, then textbox1 and textbox2 will look at the closed files in a particular column.

Any help woul be appreciate it.
Many thanks and regards,
Harto

[Bob Phillips]

Simplest way is to open the workbooks, get the data, then close them again.