Hello,
I have an Access query that creates a data table based on user defined parameters.
The data table is linked to excel, with a shared connection to access.
I found some VBA code to run an access macro from Excel, that basically reruns the query and updates the access data table.
The issue i am having, is that I can't run the Excel VBA code with the Shared Connection, as it shows an error saying it is unable to delete the data in access, and therefore cannot complete the query.
The Excel VBA only works when the shared connection is removed.
How can I run an Access Macro from Excel using VBA, so that the access table is updated, and then the linked shared connection table in excel is refreshed and new data is shown?
Thanks!
I have an Access query that creates a data table based on user defined parameters.
The data table is linked to excel, with a shared connection to access.
I found some VBA code to run an access macro from Excel, that basically reruns the query and updates the access data table.
The issue i am having, is that I can't run the Excel VBA code with the Shared Connection, as it shows an error saying it is unable to delete the data in access, and therefore cannot complete the query.
The Excel VBA only works when the shared connection is removed.
How can I run an Access Macro from Excel using VBA, so that the access table is updated, and then the linked shared connection table in excel is refreshed and new data is shown?
Thanks!
