clicking a button on a promt box VBA

Hey,

I have VBA code written to run solver with various scenarios. each time a scenario runs solver promts a promt box. I need to hit ok everytime for it. the code takes a while to run, so i would like to have a piece of code which does this for me so i can continue on other work. I have tried using application send keys, however it is not the most efficient and it doesnt always work :s Is there a better method?

thanks,

I have also tried

docmd.select.ok but it doesnt work. does anyone have an idea?

Did you try?

Please Login or Register  to view this content.

Alf

yes I did. sry i forgot to mention that. for some reason the dialog box still promts with that. there has to be a way. Send keys works for all of them but the first one. but i dont inderstand since i have it on a loop. It doesnt make any sense

Strange as this works fine in this microsoft example for solver in a loop:

Please Login or Register  to view this content.

Perhaps you could upload a sample workbook with your macro?

Alf