Import worksheet add-in?

[l8sk8r]

Hi All

I found this script on the net which I think is very good for importing multiple workbooks/worksheets into a current workbook.

It works fine when running as a module, but when I change it become an add-in it gets a bit a confused when trying to move sheets.

I'm pretty sure its something to do with the way thisworkbook is referenced. From some of the suggestions I see it could fixed by setting-up a class module, but it sounds like i'd have to do that for every workbook i wish to import worksheets into.

Unfortunately my coding experience is not good enough to come up with an answer at present. Any ideas how to append this?

-----------

Courtesy of erik.van.geit
http://www.mrexcel.com/forum/showthread.php?t=157175

Please Login or Register  to view this content.

[Andy Pope]

Thisworkbook object refers to the workbook containing the code being executed. I your case the addin.

Instead you would normall use the ActiveWorkbook object.
In this particular code you need to create a reference to the activeworkbook before opening another workbook, which would then become the active workbook.

Please Login or Register  to view this content.

[l8sk8r]

Cheers Andy! That's really useful to see this working. I tried to reference the activeworkbook previously but I must have made a mistake somewhere. Thanks for your help!!