Creating a Macro to Copy a sheet to several workbooks

[Jonny5isAlive]

Hi,

I am fairly new to the whole Macro scene and need some help please. I am looking for a macro that will copy a sheet from 1 workbook and copy it into several closed workbooks, all saved in the same folder. I have been playing with the below but can't seem to get it to work. Any help greatly appreciated.

Please Login or Register  to view this content.

[Norie]

How is the code not working?

[Jonny5isAlive]

Hi,

It does not seem to be doing anything. I click on Run and no error messages or anything but the files in the folder also haven't been updated. All the tabs on the destination workbooks are hidden if that makes a difference? Thanks

[Norie]

In the first If statement for checking the file extension you have ThisExt, surely it should be FileExt.

Please Login or Register  to view this content.

By the way, those if statements seem a wee bit convoluted, what are you actually checking for?

[Jonny5isAlive]

To be honest mate I picked the code off the web to try and resolve the issue. I'm more than happy to start from scratch to solve my problem if anyone can point me in the right direction.