Help with VBA script for Excel
I'm trying to write a script to navigate to the Solver check-box under References in the Editor. So far I have:
application.sendkeys (%)
application.sendkeys (L)
application.sendkeys (V)
That gets to the VBA Editor.
I cannot figure out how to code the next steps:
Click on "Tools"
Click on "References"
Click in the Solver box.
Any help or suggestion would be appreciated.
|