Crawl Sheets with Macro

[excelcandy]

The following code is supposed to get sheets from a closed workbook, but instead it opens two new ones and deletes the macro. Is there a better way to import or can you help me to fix this one? I would also like to only import a single sheet from a closed workbook.

Please Login or Register  to view this content.

[excelcandy]

posted late on a friday, so obviously no response, so any help ?