how to import data from external excel source?

[secoo140]

Hello,

I want to create a command button in my excel find to find necessary values in an external excel file.

as in many programs, I would like to click on the open file option and select the target file with the windows search interface.

as an example I installed a page of a simple windows program. I guess it is possible to achieve the same thing with VBA.

thank you

 

[rpaulson]

try this.

fName = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "*")
If fName = "False" Then Exit Sub
Workbooks.Open fName

hth,
Ross