Dear MVP's:
I would really appreciate help with this...
I have an access database that contains a macro which runs a query. I would like to know how to automate this macro so that it runs this query and copies query results from access to excel, refreshes the pivot tables and saves a copy of the report to a folder. The source file is also copied over. I do not know VBA. Is there a simple way to do this?
Any thoughts or suggestions would be greatly appreciated.
Thank you,
Lisa
I would really appreciate help with this...
I have an access database that contains a macro which runs a query. I would like to know how to automate this macro so that it runs this query and copies query results from access to excel, refreshes the pivot tables and saves a copy of the report to a folder. The source file is also copied over. I do not know VBA. Is there a simple way to do this?
Any thoughts or suggestions would be greatly appreciated.
Thank you,
Lisa