If you're opening a text file, you'll probably want to parse each field
according to rules that only you know.

I'd suggest that you record a macro when you do it manually and you'll have code
that works ok.

tom wrote:

In MS-excel2003, when we click on a button we have to open a txt file which
we already assigned.Please suggest vba code for this.

--

Dave Peterson