VBA to copy the contents of the sheet in a template file to all of the files in a folder

Hopefully a nice little easy one for someone...

I'm after VBA to copy the contents of the sheet in a template file into all of the files in a folder.

The template will be getting updated every month (extra rows) and the sheet name will already exist in the individual files within the folder so maybe better to copy the contents rather than the sheet??

Thanks in advance...

try

Please Login or Register  to view this content.

Thanks very much k1dr0ck, that works really well.

As the file location could be on a network/cloud etc, I've tried to make a tweak to it for the filepath

sPathName = Application.ActiveWorkbook.Path

It runs but it doesn't update do what I want it to do (but your c:\ etc path does).

Can you please correct the error of my ways.

Many Thanks,

haven't had experience working with network or cloud drive
try

Please Login or Register  to view this content.