You don't have to open the file and you can just get the file path:

strFilePath = _
Application.GetOpenFilename(FileFilter:="Text Files (*.txt), *.txt",
_
Title:="Point to a text file")

MsgBox strFilePath

You also could use this one:

vDialogResult = _
Application.GetSaveAsFilename(InitialFileName:=str DefaultFilePath, _
FileFilter:="Text Files (*.txt),
*.txt")


RBS

"dok112" wrote in
message ...

thanks for the answer to the first one.

for 2, I dont want it to open the file. I just want it to put the path
for it. What I'm trying to do, is write a macro that is going to run
down a list of these and email the file at that path to the person in
A1....


--
dok112
------------------------------------------------------------------------
dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=500430