This might sound odd, but I'm trying to figure out possible solutions to a problem. My idea in this case would be to use Access to create an Excel file (simple enough) but not only would I want it to write the table data into the file, but I would also like it to copy/export a selection of VBA into the workbook, so that when that file is opened, a workbook open event could execute. The latter is the part I need help with. I've got everything setup and the finished file being created. Now, if there's a way to "send" a module into the created Excel file - that might solve my issue. Thoughts?
Thanks,