Importing txt file

[Kizzz]

Hello -

I'm trying to write code that will import a text file into a workbook without having the user go through the import wizard. I know that the text file will be two columns delimited with an equal ('=') sign. What I can't control is the name or location of the file. I'd like to allow the user to browse to the location of the file, select the file, and then have the macro do the rest.

Any help is appreciated.

 

[Norie]

Try using the GetOpenFilename method.

 

[Kizzz]

That works great.
Thanks Norie.

 

[Greg Truby]

Looks like Norie's got you all sorted out. But should you want to learn more, you might take a look at the FileDialog object too and play with that when you have a spare moment. It's a little more configurable than the GetOpenFilename function (not that there's anything wrong with GOF(), mind you, just another tool in the box).