Using Excel macros to Copy, create and email.

Hi All.

I have no experience with writing VBA but I want to create a new Excel form that will have a couple of 'buttons' for doing a number of things.

First the user will fill in a project detail, Name, project number and project lead. Then I want to have a button that will copy a template folder and rename it to ProjectNumber - ProjectName, like this (except I and a total noob at this and want more help)

http://www.excelforum.com/excel-prog...-with-vba.html

At this point the form will still be open and the user will then fill in the people who require permission to this new folder and what access they need. The next step is to click a second button to save in the new folder document location, e.g. "\\Server\Projects\ProjectNumber - ProjectName\Documents" and email the internal support team who can then implement the required changes by creating the security groups and adding them to the folder.

Look forward to your advise?

Thanks MikeTRON.

So my first question would be where is some good online resources to investigate VBA scripting in Excel, be a good start to understanding the basics.

thanks mikeTRON , looks interesting, going to take a long read and go from there.