opening text files

[birdman]

i am using the code

Dim FileName as String
FileName = Application.GetOpenFilename

to receive the name of a file that will eventually be opened. the file that will be opened must be a text file. does anyone know how to have only text files appear when the open box appears? thanks for any help in advance.

 

[Andrew Poulsom]

From VBA Help:

fileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")

 

[birdman]

shuld have looked in help first. sorry about that. thanks for the help.

 

[Norie]

Try this.

MyFileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

By the way you shouldn't declare the filename as String as it will generate a type mismatch if Cancel is pressed.