XL: Using the /F Switch to Load Add-in Macros

• Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
• Microsoft Excel for the Macintosh, version 4.0

SUMMARY

An OPEN= statement in your Microsoft Excel settings file (EXCEL4.INI in version 4.0 for Windows, EXCEL5.INI in version 5.0 for Windows, or Excel Settings (4) on the Macintosh) will open the specified document automatically at startup. In addition, you can use one or both of the following switches to control how this document is opened:

   /R causes the document to be opened read only

   -and-

   /F causes the document to be fast loaded.

When you use this switch to open an add-in macro, /F lists all of your add- in's custom function macros in the Paste Function dialog box. However, to get the "fast load" functionality, the add-in macro must also contain the defined name __DemandLoad. With the combined /F switch on the OPEN= line and the __DemandLoad defined name, the actual add-in is not loaded until you enter or recalculate one of its custom functions.

NOTE: The actual definition of __DemandLoad is not important; you can use the Boolean value of TRUE, for example.

MORE INFORMATION

The /F switch behaves as follows depending on the type of document you are loading on the OPEN= line:

• Template: the template is placed in the New dialog box (from the File menu, choose new).
• Macro Sheet: All custom functions on that macro sheet are placed in the Paste Function dialog box; the macro sheet is opened when one of those functions is used.
• Add-in Macro Sheet: All custom functions are placed in the Paste Function dialog box. The add-in file will load when you use one of its custom functions ONLY when the name __DemandLoad is ALSO defined on the add-in sheet. Unless you have both components, /F in the settings file and __DemandLoad on the add-in sheet, the add-in will not load on demand but instead will be fully loaded when you start Microsoft Excel.

Alternatively, you can directly edit the settings files. In the Microsoft Windows operating environment, you can use a text editor to add OPEN= statements, as well as other settings, to the EXCEL4.INI file (version 4.0 for Windows) or the EXCEL5.INI file (version 5.0 for Windows). See the EXCEL4INI.TXT file for additional information. If you are using Microsoft Excel for the Macintosh, the counterpart to the EXCEL4.INI file is the Excel Settings (4) file. To make modifications to the Excel Settings (4) file, you must use the ResEdit utility. ResEdit is available through Macintosh user groups, or the Apple Programmers and Developers Association (APDA).

REFERENCES

"EXCELINI.TXT" "SDK User's Guide," page 441