Hello,
I am working on automating something where I use a combination of Excel & Access. Here's a small breakdown of the structure of it.
Button in an Access form that runs the following code through VBA
- Runs Excel Macro in workbook A
- Click (2) buttons in Access form (same form as my button that runs everything) that contains Delete & Update queries respectively
- Run Excel Macro in workbook B
- Run Excel Macro in workbook C
I have figured out how to run macro in workbook A from Access (and probably will be able to in B & C as well), but I am having a problem with the VBA code used to click the two buttons. After running Excel macro in workbook A from Access, what is the code to click the two buttons in my form to run the Access queries?
Appreciate the help!