Hi Summer123,
I'm working on a project now that is I would say exactly the same as yours - trying to export Access data into separate formatted Excel tabs. Did you get yours resolve? I wonder will you be able to help me? My VBA is worse than yours. Please advise. Thanks in advance!
I have been using Access for a while now, but not much experience in VBA. I found this site while I research for a solution on the project I'm trying to do. Hopefully, someone will be able to help me!
Thanks in advance!