file open

External Since: Sep 06, 2006 Posts: 1

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.

External Since: Feb 11, 2005 Posts: 579

On 9/6/06 2:21 PM, in article
54321792-04CA-4E1F-B57C-F324E36E234D DeleteThis @microsoft.com, "Judge"
<Judge DeleteThis @discussions.microsoft.com> wrote:

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

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom