VBA Copy Active worksheet to all workbooks in folder

[adainty]

Hi VBA Guru's

I've been looking all day for Copy Active worksheet to all workbooks in folder. I need to copy my sheet "Data Overview" to all workbooks in C:/Asia, I'm using excel 2007 I tried this code below but it says it can't open the file error 1004

Please Login or Register  to view this content.

Thanks in advance

[tigeravatar]

adainty,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar