Macro that exports data from form to folder

Form? Is this a userform? Or is your data in worksheet cells? Would your backed up data be restored to the exact same structure as it was saved from? Will you utilizing this data for anything other than restoring it to the same cells it originated from?

Thanks, Tom

"I want to save a few of the fields to a folder: (from the example) So I would save by date and include Location, Event, and the Label Types for example. It could work by just saving those items to a new worksheet I think."

My answer to you would depend on "what" you will be doing with your backup data. Now that your data is backed up somewhere. What now? How will you use it. What level of access or flexibility do you need for working with your data?

For example, the field in A2, Location, might contains a dropdown list of all locations and load a "backup" into your form after a selection has been made. If there are multiple records for the same location, you might need to select a date and/or event to narrow down your returns. I do not have a clue.

If you simply need a list of these field and have no intentions of using the data except for manually viewing it, please say so..

I see what your saying. Currently I go through the process of copying data from this form to another folder manually on a regular basis, and I want to "automate" the process. Additionally, if all the data was saved consecutively, in one worksheet, I could perform a trend analysis on it, whereas currently I can't because each form is saved seperately, and the data isn't arranged in a way that I could perform a trend analysis.

Thanks for the responses.

Ok. So you simply want to transpose your form into a single record. It might be as simple as:

Please Login or Register  to view this content.

This would append your form data to a csv file or create the csv file if it does not exist. This is the simplest example that only takes into account a file being locked by another application. As is, it allows for duplicate entries. Is this a problem? You can arrange the print operation as you wish. The example above, using your attached example, is saving the location, date, and time.

Is the path you are saving to a local or network folder? Will multiple users be updating this file at the same time from different workbooks?

Thanks for the help Tom,

I would be recording the macro to a Network folder, and that is a problem I ran into. Otherwise, I guess I could just record a macro, open the designated workbook, copy and paste the individual cells and add a loop so it doesn't copy over the old information.

Additionally, there would be more than one person using this at the same time, so I wasn't sure if that would be a problem.

I apologize, but I don't understand the code in your post; I tried to run it, but I'm not sure what I'm looking at. Also, security isn't a concern.

The only code I have so far is from what I record, and I don't know where to add the loop.

Thanks again for all help.