file open

J

Judge

im writting a macro in excel which requires that i import data from a txt
file. ok. the txt file changes on each ocaasion. how do i from excel tell the
macro which file to open and from which location.
pls help thnx.
 
B

Bob Greenblatt

im writting a macro in excel which requires that i import data from a txt
file. ok. the txt file changes on each ocaasion. how do i from excel tell the
macro which file to open and from which location.
pls help thnx.
Click to expand...
Check VB help for GetOpenFileName. This function will let the user navigate
to the file, and returns the full path. You then use that to open the file.
 
Top