Dynamically clicking a command button on a worksheet using macro

[LSTAN]

Hi

I have a workbook that is use to retreive data from the database. The workbook has a command button where when the user click it data will be retreive from the database.

I was thinking of automating the whole task without any user intervention.

Does anyone know of any code that can do that?

Thanks in advance.

 

[PHV]

Put your actual code in the Workbook_Open() event procedure.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LSTAN]

Thanks PHV

Why i have not thought of that!!!!
The code that reside in the commandbutton is just a Call function!

Thanks.