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!!