Macro to create zip files from form to capture data.

Hi there,

I'm looking for some help please, to solve a problem I have with a series of excel documents I'm working on.

Although I've used this forum before to find workarounds for various projects, I've never actually had to ask for a specific answer until now. So any help would be really appreciated.

I currently have a form that I've created in one workbook (called "New Evaluations Request") with several formulas, radio buttons, combo boxes, input boxes, calculated cells etc. and various buttons for performing certain functions.

The form itself collects data regarding a particular "New Evaluation Request" where the person filling in the form can capture any relevant data that will be required for use by several people.

One of the buttons within the form, when pressed (called "Record Evaluation Request") takes all the data from within that form and pastes it (as values) into a single row in a table in another workbook (called Evaluation Records) where all the data is recorded and used by several people with access to this workbook for various reasons such as prioritizing workloads, improving response times etc.

Whilst this happens, the workbook is saved as another excel file with another name (so the original file can be used again), in a particular location, based on values in 3 separate cells which identifies it by customer, project name and evaluation number with a prefix of "Evaluation Request". So an example file name might be "Evaluation Request 99 Customer 1 Project 1" for instance.

Also a PDF version of the form is saved in the same location with the same name.

The folder where these files are currently being saved is called "Waiting" and within the "Evaluation" Records" workbook there is a cell that has a concatenated hyperlink which links to a .zip folder which I currently have to manually create and place both the saved excel file and the PDF inside.

What I'd like to do, and the reason for asking for help today, is to add some code so that when the "Record Evaluation Request" button is pressed, a .zip file with the name "EVAL REQUEST 99" for instance, is automatically created in the same "Waiting" directory (or in another directory as the case maybe going forward).
with these files automatically located inside, therefore being located precisely where the concatenated hyperlink points to, making the entire process automated and less likely to experience any errors.

If possible I'd also like to duplicate this zip file into another location where it can be stored as a backup in case of damage or mis-placement by one of the other users.

Firstly, is this possible and if so could anyone kindly assist and offer some suggestions on how I'd need to go about it.

I trust that there's enough info above to give you a good understanding of what's needed and I'll be looking forward to any and all assistance with this problem.

Thanks in advance.

I'm guessing that this isn't possible given the absence of any replies.

I'll try something else.