file open

[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.

 

[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.

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.