VBA - MS Access
What is the best way to approach this problem?
I am trying to put a programming spec together.
1. I have a filtered query of data on a form
2. Each row of data needs to be exported as a unique workbook
3. File name for each workbook is derived from the row of data
4. An existing excel template is chosen for the new workbook based on data in the row
5. The data in the query changes so the exports will become updates
6. Maybe a master button on the form for the first bulk series of exports
7. After the first bulk export there needs to be automatically created at each row of data in the form a command button to Export/Update/Goto Workbook
8. If new data in the form then there needs to be a way to deal with that