"jjnotme" wrote in message
...

Thanks to everyone who has been helping me with my macro.
I have another question.
I need the sheet to have the same name as the file name. I got it to
work by using an input box, where the user has to enter the file name.
I would like to avoid having to use the input box, and have the macro
do it automatically. Is there any way to do that? I am using Excel
2003.

Thanks, Carol

In general, filenames might be too long, or contain characters not allowed
in sheet names.