Get VBA to allow user to Browse for a file to open

Hi,

I am very, VERY new to VBA so apologies if this is general knowledge.

I am writing a macro that takes a dump of data in a text file, converts it to columns in excel and copies it to an Access Database.

My code for opening the text file is simply

Please Login or Register  to view this content.

However, what i would like is for the user to be able to browse to find the text file and if it isn't too much trouble, for a warning to be presented if they try to choose a file that isn't a txt file.

Thanks in advance for any help you can give me.

J

This thread is a duplicate.