VBA: Opening a .txt chosen by the user

[lucas.cioffi@gmail.com]

I've found out how to open a .txt using VBA, but does anyone have ideas
how I can prompt the user to find the correct .txt for importing data,
as the location of their data would probably change depending upon
where they last saved it?

Thanks,
Lucas

[lucas.cioffi@gmail.com]

answer found:
http://groups.google.com/group/micro...d0bff2c134d418

[Tim Williams]

look at application.getopenfilename

Tim


<lucas.cioffi@gmail.com> wrote in message news:1147836950.458155.156230@i40g2000cwc.googlegroups.com...
> I've found out how to open a .txt using VBA, but does anyone have ideas
> how I can prompt the user to find the correct .txt for importing data,
> as the location of their data would probably change depending upon
> where they last saved it?
>
> Thanks,
> Lucas
>