MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing multiple text files into Excel2000

Posted by Steve Nova on June 13, 2001 7:58 AM

Hi, I have been tasked with providing an interface (a form?) a user will be presented with when they start up an Excel2000 file that will display a text box containing the path name (default) where a group of text files are situated, also a button (Import) that when pressed will import each of these files 1 by 1 into the Excel workbook(sheet?) - by now you can tell I am a complete novice (how did I get this task?) with Excel!! HELP!! Has anyone done anything similar?

I"d appreciate even knowing whether I should be using VB or VBA or a Macro.

Hope you guys can HELP!!

Cheers........Steve Nova..

Posted by Barrie Davidson on June 13, 2001 9:19 AM

Have a look at

The code was written for Excel97, and I don't have Excel2000, so I don't know if it will work in Excel2000 (I assume it will). If you need any explanation let me know.