Interacting with Forms
I have a program that is installed as an excel addin and I want to automate
some processes I do with this program. I am using this code to open a form
where I need to change some options before performing another operation:
Set C = CommandBars("Worksheet Menu
Bar").Controls("MyToo&ls").Controls("&Template Options")
C.Execute
This successfully calls the form, but I don't know how to change the options
in the form. Is there a way to do this?
Thanks!
|