I have a form in a separate workbook that is used by a macro in that
workbook to present a form to the user to fill out interactively for
creating some charts. This works great but it requires manual effort
and I want to automate filling out the form.

So essentially I would like to have a macro in another workbook open
this form, fill it out, and then click the OK button. I'm wondering
if this is really doable.

From what I've been able to gather by searching this newsgroup, I
would need to create a "helper" macro in the other workbook just to
open the form. But that doesn't address filling out the form data and
"clicking" the OK button.

If it is possible to fill out the form programmatically, does this
need to be done by a macro in the same workbook as the form? If so, I
could pass the data in as parameters to the helper macro and have it
fill out the form when it opens the form.

Thoughts or advice?

Denis