how to import data from external excel source?

secoo140

Board Regular
Joined
Oct 12, 2013
Messages
70
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

Well-known Member
Joined
Oct 4, 2007
Messages
1,074
try this.
Code:
fName = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "*")
If fName = "False" Then Exit Sub
Workbooks.Open fName
hth,
Ross
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top