Mister_joe
07-08-2014, 04:11 AM
Hi All,
I am looking to export data from an Access file to a macro-enabled Excel file. For now, I have no idea how to use codes in Access to open the Excel file and enable the Macro on the Excel file before populating it with the data imported from the Access database. Please, suggest possible options that can lead me to the end goal. This is very important for me.
In case I haven't made it clear enough, please, see the attached image file. Rather than do this manually, I need to use codes to do it.
Thanks.
I am looking to export data from an Access file to a macro-enabled Excel file. For now, I have no idea how to use codes in Access to open the Excel file and enable the Macro on the Excel file before populating it with the data imported from the Access database. Please, suggest possible options that can lead me to the end goal. This is very important for me.
In case I haven't made it clear enough, please, see the attached image file. Rather than do this manually, I need to use codes to do it.
Thanks.