Workbook creating

When you Save a newly created workbook, the Save dicdog box will prompt you to assign a name to the document. Excel for Windows automatically appends a three-letter filename extension (e.g.,. xls) to identify the file format type. 

The other is the Organic Structure Elucidation workbook, created by Professor Bradley D. Smith (Notre Dame) ... 

An alternative, total energy, will be used throughout this workbook. The total energy is the heat of a hypothetical reaction that creates a molecule from a collection of separated nuclei and electrons. Like the heat of formation, total energy cannot be measured directly, and is used solely to provide a standard method for expressing and comparing energies. 

An additional possibility is to create a list of the audit trail. In this instance, you must save the workbook first. 

The default Excel 2000 workbook contains three worksheets. If you want a workbook with more than three sheets, you can insert additional worksheets, or choose Options... from the Tools menu and choose the General tab, change the Sheets In New Workbook default, then create a new workbook. 

When you create a new workbook, the sheet tabs have the names Sheetl, Sheet2, etc. To rename a sheet, double-click on the sheet tab. The sheehicime will be highlighted and you can enter a more descriptive name, as, for example, in Figure 1-2. Click outside the sheet tab to exit from edit mode. 

You can create custom number formats. First, choose the Custom category from the list of numbers formats. This will display the list of (so far) built-in number formats. To add a new, user-defined number format (it wiU be added at the bottom of the list), type the format in the Type box. For example, if you want to display numbers to four decimal places, type 0.0000 in the Type box. The new format will be stored in the list of formats so that you can apply it to other cells the format will be available in all sheets in the workbook. 

There are two ways to create a chart either as a separate chart sheet in a workbook, or as a chart embedded in a worksheet, so that you can see both the data and the chart at the same time. An embedded chart is useful if you want to see how a curve changes as you change its parameters. As you change the values in worksheet cells, the chart will update automatically. 

The fourth dialog box allows you to create the chart either as a new chart sheet, which will be inserted in the workbook, or as an embedded chart on a worksheet (Figure 2-4). 

External references are used to establish links between documents. You can create a link between worksheets within the same workbook, or between worksheets in different workbooks. By linking worksheets, you can utilize the data from one worksheet in a formula in another worksheet, merge data from several worksheets in a summary sheet, or simplify a complicated model by breaking it up into manageable portions. 

The Create Names dialog box lists all names that have been assigned in the workbook, even if they are no longer used or valid. If you have removed an unwanted name by deleting the cell, row or column in which it was located, the reference to that name in the Refers To box will be REF . Use the Delete button to delete unwanted or invalid names from the list. 

Use Create Names to assign the name to the cell or range in the range of selected sheets. This procedure will assign a global name in the workbook but will "overwrite" this global name with a local name in all of the selected sheets except the active sheet... 

When you press Finish, a new Excel workbook will be created to contain the data. The parsed data is shown in Figure 7-7. 

Normally the Personal Macro Workbook is hidden (choose Unhide... from the Window menu to view it). If you don t yet have a Personal Macro Workbook, you can create one by recording a macro as described earlier, choosing Personal Macro Workbook from the "Store Macro In" list box. 

Unfortunately, if you re entering the custom function in a different workbook than the one that contains the custom function, the function name must be entered as an external reference, e.g. PERSONAL.XLS FtoC. This can make typing the function rather cumbersome, and means that you ll probably enter the function by using Excel s Paste Fimction. But, see "Creating Add-In Function Macros" in Chapter 17 for a solution to the problem. 

If you create a macro to be used by other people, you can make it easy for them to use the macro by installing a custom menu command. As well, you can install the new menu command by means of an automatic procedure, so that all the users have to do is open the macro document. There are two ways you create an automatic procedure by creating an Auto Open macro in a module sheet, or by creating a Workbook Open event procedure. These are described in the sections that follow. 

To install a new menu command whenever Excel is started, create an Auto Open procedure in the Personal Macro Workbook. To install a new menu command when a particular workbook is opened, create an Auto Open procedure in that workbook. Use the MenuBars and Menus VBA keywords to specify where the new Menultem is to be added, with the Add keyword. The syntax of the Add method is ... 

From the preceding examples it should be clear that you can create automatic procedures that install a menu command when a particular workbook is opened and remove the menu command when that workbook is closed (using the Workbook BeforeClose event procedure). Or you can install a command when a particular worksheet is activated and remove it when that worksheet is deactivated. 

Custom toolbuttons were created for the Full Page Portrait, Full Page Landscape Chemical Format H2O and Toggle Between Floating Point and Scientific macros. The Chemical Format macro is described in Chapter 16. Module sheets containing these macros should be saved in the Personal Macro Workbook. 

Product and reagent location tracking is one of the most important functions of a reaction workbook due to the spatial orientation of the product arrays generated by HTOS techniques. The locations of reagents together with the volumes to be transferred and the sequence in which the reagents are to be delivered will be used to automatically create synthetic procedures for a liquid-... 

In acid solution, cobalt creates a Ji-stabilised cation at the site of the OH group that cyclises onto the allyl silane with the expected regioselectivity and excellent enantioselectivity. The nature of the cation stabilisation and the removal of the cobalt are discussed in the workbook. The structure of this group Co(dmgH)2py is explained in the workbook. 

This method has been applied to a synthesis of the alkaloid O-methyljoubertiamine. Reaction of the lithium derivative of 125 with the part-protected diketone 128 gave an enamine 129 that was immediately allylated to create the quaternary centre in 130. Deprotection and cyclisation completed the cyclohexenone28 131. A discussion of the strategy and further details of this synthesis are in the workbook. 

The 65 page Secrets To Creating Chemistry Seminar Manual / Workbook. 

Starting with Excel 97, the modules are also stored together with the workbook, but they are not as readily visible. To generate a new module in Excel 97, Excel 98, or Excel 2000 requires the command sequence Tools => Macro => Visual Basic Editor, followed by Insert => Module. From then on, you can switch between spreadsheet and module with Alt + F11 if your keyboard has an FI 1 key. Otherwise, use File => Close and Return to Microsoft Excel (or Alt + Q) to move from module to spreadsheet, and Tools => Macro => Visual Basic Editor to get from spreadsheet to module. Unfortunately, you can no longer use the spreadsheet tab to create or switch to a module. In summary, starting with Excel 97 the corresponding procedure is as follows ... 

---