I see you have 3 threads asking the same question.

I'll bow out of the conversation.



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