Launching MIMICExcel.
Embedding a query.
Using the MIMICExcel Advanced Refresh Mode option.
Using the Query Manager in MIMICExcel.
Exporting an embedded query.
MIMICExcel is an applet or application that you use from within Microsoft Excel®. When you open Excel and then run MIMICExcel, you have all the functionality of MIMIC from within the Excel environment. With MIMICExcel, you can seamlessly incorporate table data from your queries into your Excel spreadsheet.
To obtain this functionality, make sure you have MIMIC version 3.0 or higher installed on your system. For details on installing the MIMIC application, see the “MIMIC Installation and Purchase Options” chapter in the Client Application Installation Guide.
 | You must have Java version 1.4 or higher. To obtain a free Java download, go to: http://www.java.com. |
After installing MIMIC 3.0 or higher, start Microsoft Excel. You will notice the addition of the MIMIC menu in the Excel menu bar, and the addition of the MIMICExcel Add-in toolbar, which contains two buttons:
The Enter MIMIC
button. (MIMIC>Enter
MIMIC from the Excel menu bar.)
The Refresh MIMIC Queries
button. (MIMIC>Refresh MIMIC Queries from the Excel
menu bar.)
To open MIMICExcel, select the Enter
MIMIC button. The first time you enter MIMICExcel, an
authentication message displays. Select Yes if you want the authentication window to come
up each time you select the Enter MIMIC
button. Select Always to always authenticate MIMICExcel
(recommended choice – you will not see this dialog again unless the
MIMIC software is upgraded).
| The MIMIC Java Certificate expired as of February 21, 2005. If you selected Always to trust the certificate, you will not see the expired certificate message and you will not be required to take any action. To upgrade your certificate, so that you do not receive an expired certificate message, please go to the “Downloads” page on the LIM Web site and install the latest MIMIC application. |
Note the following information regarding expired certificates:
If the certificate displays with an expired message, MIMICExcel can still be started by selecting Yes or Always.
Users who have selected Always to trust the certificate will not see the expired certificate message and will not be required to take any action.
MIMIC stand-alone is not affected by the expired certificate.
Once authenticated, the MIMICExcel window displays:
The MIMICExcel interface is the exact same as the MIMIC interface
with the addition of the MIMICExcel toolbar at the top of the window.
The MIMICExcel toolbar contains three buttons: 1) The Back to Excel 
button to close MIMICExcel and return to the
Excel spreadsheet (If you close MIMICExcel instead of using the Back to Excel button, it will take longer to open MIMICExcel
the next time.), 2) The Query Manager
button to manage previously saved embedded
queries in MIMICExcel and 3) The Embed
Query 
button to save or embed an active query within
MIMICExcel.