Compatibility: Web based, offline version for Windows, Mac OS X and Dedicated apps for Android & iOS platform. Get Google Sheets. If you are a iOS or Mac OS X user, then you should opt for Numbers instead of Microsoft Excel. Number is a built-in spreadsheet creating tool in Apple devices that is completely free now.

So, when Solve is called, it uses the Excel Add-In Solver to read in input parameters for the Solver prompt and then commence the calculation. Once the calculation is complete, a summary dialog box appears which must be dismissed by clicking 'OK' or hitting 'Enter' on the keyboard. This is the reason for using SendKeys here. The ultimate aim is to perform this task 40 times, setting constant to a new value for each iteration, and print each set of resulting values as a separate line in a list on the spreadsheet. Virtualbox 4 3 14. – Jun 24 '17 at 17:38. How to use mac terminal like putty.