Ewan,
Personally I always used .GetOpenFilename.
Help shows you the way.

nickHK

"ewan7279" wrote in message
...
Hi,

I have never used either of the above applications, so am unsure which to
choose. My problem:

I need a user to give the location of a text file, which then opens and is
used as a reference point for the rest of my macro (I am basically
converting
text information into spreadsheet information). However, I do not want
the
user to go through the text wizard to avoid upsetting the rest of the
macro.

I currently get the user to type the location of the text file into a cell
of a spreadsheet, but the above applications would be more user-friendly.
Which one should I use, and what would the syntax be?

Thanks in advance,

Ewan.