Hello,

I have 2 questions:

I have an excel worksheet with 4 sections. I get my data from 4 users.
I created 4 files (one file for user). Each file contains user's
section.
My problem is that I update my worksheet frequently and I want to
automate the creation of users files. How can I do it using VBA ?

I want to backup my excel file (and all the files within its directory)
to a new folder.
How can I do this using VBA ?

Thank you
Gil D.