阅读背景:

VBA解算器禁用每次迭代后弹出的对话框

来源:互联网 

I am using the built-in solver in Excel 2007 within a VBA loop to solve a number of different problems. Occasionally, the solver hits the maximum time, which causes a pop-up dialog box to appear asking whether the user wants to Continue, Stop, or End. In all cases I want it to end, and proceed to the next line of the loop. This will prevent a user from having to sit there and respond each time.I am using the built-in solver in Excel 2007 wi




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: