If your analysis takes a while to complete, you may want to provide some feedback to the user on how the analysis is proceeding. You can do this by using the ExcelStatus function. This writes status information to the status bar at the bottom left-hand side of the Excel window. In the final line ExcelStatus is called without arguments in order to return the status bar to its default state. Notes • Writing status messages makes the analysis section of your notebook Excel specific. However, this may be required for longer routines. • Writing status messages can also be a good way to see which part of your analysis is taking up the most time. If you would like to ask the user to select a range or specify a file name during a macro, you can do so using the ExcelDialog function. The symbol $ExcelDialog gives a list of available dialogs. | Out[9]= |  |
This displays the "Range" dialog. | Out[10]= |  |
Notes • When running code from Mathematica, you need to activate Excel first to interact with an Excel dialog. |
