#1. How many files with the extension of .txt are in that folder?

#2. I don't see how the code I posted names the worksheet.

#3. I don't understand what this means.

luis wrote:

Hi Dave,

Thank you very much for your reply. I copied your code into a module in
VisualBasic and changed the folder to check. This is what happens when
I run the macro:

1) It copies the data of the first file of the folder appropriately
into the first column of the active worksheet.
2) It appropriately labels the tab with the name of that file.
3) It opens a new worksheet with the name of the file only.

But it stops there. Any ideas?

Thank you very much,

Luis

--

Dave Peterson