I'm modifying an existing Interactx project that calls two different applications written years ago. The applications do not initialize on the latest HMI even though the operating system and deployment server are the same as the previous versions.
I'd like to know if it is possible to perform these tasks directly from the Interactx vba.
1. I need to copy one table from a database that is loaded by the Interactx application from access to excel and save the file.
2. I need to clear the access table of data in preparation for the next run.
I'd like to know if it is possible to perform these tasks directly from the Interactx vba.
1. I need to copy one table from a database that is loaded by the Interactx application from access to excel and save the file.
2. I need to clear the access table of data in preparation for the next run.