1

hello, and thanks in advance.

i am very rusty, I used to use Access all the time, but that was many years and many version ago…

I made a table and a form, I wish to use data in a form field to create and name a folder.

ie… on the form, I have a field for client

I wish to create a button macro? that will create a folder name %client%

then I have about 6 word documents all named A_template, B_template, C_template

I wish to create a macro? that will:

copy A_template c:\clients%client%\A_%client%

copy B_template c:\clients%client%\B_%client%

copy C_template c:\clients%client%\C_%client%

the question is: do I create a macro? a batch file? or…grrrrr…code? (not much of a coder)

thanks in advance!

4 Spice ups
2

In the form design view create a button.

In the on click event of the button add some VBA in there and it it should be pretty simple.

Here is a link on creating a folder in vba.(Dont forget the reference mentioned.)

And here is a link on copying files over.

http://stackoverflow.com/questions/16943003/vba-to-copy-a-file-from-one-directory-to-another

2 Spice ups
3

wow, thanks Rage!

4

No problem. If you run into any code problems with it, just post what issue you are facing.