I have a simple table with two fields that I want to export into multiple Excel Spreadsheets using the value in field one. I've looked at many different sites and most show how to export the data into multiple tabs of one workbook. I need multiple workbooks, named useing the values in Field 1.
Field 1 Field 2
For each change in Field 1 value, I want to create a new workbook in a directory, H:\Temp, and name the file using the field 1 value like Joe.xlsx.
Thanks in advance for some coding help.