From: Luna Moon on
how do I click a button in an Excel sheet automatically?

And then save the sheet?

And then open the other sheet into the same Excel process?

I was told that the two sheets should be opened in the same Excel
process....
From: Walter Roberson on
Luna Moon wrote:
> how do I click a button in an Excel sheet automatically?
>
> And then save the sheet?
>
> And then open the other sheet into the same Excel process?
>
> I was told that the two sheets should be opened in the same Excel
> process....

Java robot class.
From: Luna Moon on
On Mar 4, 11:48 am, Walter Roberson <rober...(a)hushmail.com> wrote:
> Luna Moon wrote:
> > how do I click a button in an Excel sheet automatically?
>
> > And then save the sheet?
>
> > And then open the other sheet into the same Excel process?
>
> > I was told that the two sheets should be opened in the same Excel
> > process....
>
> Java robot class.

but that class literally needs me to specify screen positionn for the
button. This is just a VBA macro button in the sheet. We would like to
operate it by name, instead of measuring screen position for it...

Any thoughts?