I have button on a form that exports data in an excel forma to a folder.
After I export the data, I right click the file and choose to the script.
I want to automate the script from within Access instead of right clicking the file and running the script.
Basically I want to remove this extra step and have it all inside of access.
How can I do this?
Not sure if my explanation is detailed enough.
Please feel free to ask a question.