Excel 2003 Macro

[thepittengineer]

I am trying to have a user type in a 4 digit number. This number corresponds to a xls file name (as if you were browsing on your computer that is what you would see). This would then open that specific workbook. After opening the workbook it would copy the only worksheet in the workbook. It would then Paste that worksheet into a already opened workbook.

Also, I need to be able to open a .all file and have it select the comma delimiter and then copy and paste that as well to a different sheet in the final workbook. That name is the same as the 4 digit number only followed by .all.