VBA Code to save an Excel file using a Form

[nagiese]

I'm trying to automate a reporting process and I've currently got an Excel file that gets populated via data in a Access database then the master Excel file is saved. Now the users want the database to also save a copy of this Excel file to a monthly folder. So the file path would have to be changed each month. How do I write VB code that will save a copy of the Excel file in a specific location which is auto populated in a form text box?

[pbaldy]

I can't resist. The answer to "How do I write VB code that will..." is, you just type it into the VBA editor.

Now, if you want to know what code to use, my first thought is FileCopy. You can use the textbox for the destination argument.

[nagiese]

Touche` lol
Thanks for the tip. I'll give it a try.

[pbaldy]

No problem, post back if you get stuck.