rchumpitaz
New member
- Local time
- Today, 14:13
- Joined
- Sep 7, 2018
- Messages
- 7
Hi everyone,
I'm trying to do this action and after several investigation I found that DoCmd.TransferSpreadsheet do the job, but just one time because when I'm trying to export the data again the data doesn't overwrite in the file and I have to eliminate the archive to generate a new one. Anyway I want to know if there's a way to open the excel file after exporting it.
Thanks
I'm trying to do this action and after several investigation I found that DoCmd.TransferSpreadsheet do the job, but just one time because when I'm trying to export the data again the data doesn't overwrite in the file and I have to eliminate the archive to generate a new one. Anyway I want to know if there's a way to open the excel file after exporting it.
Thanks