to answer my own question...

obviously make sure that the click method is not private before posting
on newsgroups :)

Cheers anyway

Chris

wrote:
Hi there,

I've got a model which I need to run many times, and I want to script
it to save my having to sit here doing it by hand...

the data which the model runs on is entered on one of the sheets (the
sheet is called "select"). On the basis of data entered by the user, a
button on this sheet is hit, and the model runs...


I want to automate the filling in of this sheet with all the
appropriate data with a script that loops so I don't have to *be* at
the computer to hit the button... This I have done


What I'm stuck on is how to automate the hitting of the button! is this
possible?

for example, how can I call CommandButton1_click() from another macro?

I want to do something like the following

sheet("SELECT").commandbutton1_click()

but it doesn't like it!


Hope this makes sense

cheers

chris