Browsing to open a file in VBA

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

Add to your module:

Please Login or Register  to view this content.

Then change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Then perhaps something like:

Please Login or Register  to view this content.

Thanks that seems to work great!

Ta very much