Microsoft KB Archive/124337

= Microsoft Knowledge Base =

MXL5: Optional INSERT.OBJECT and OLEObject Arguments Recorded
Last reviewed: June 5, 1997

Article ID: Q124337

5.00 MACINTOSH kbprg kbole xlmac

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 5.0

SUMMARY
In Microsoft Excel, when you turn on the macro recorder, and you insert an object using the Display As Icon option, the arguments IconFileName, IconIndex, IconLabel (icon_file, icon_number, and icon_label for version 4.0 macro) are recorded. These arguments are optional on the Macintosh; they are not needed to insert an object using an icon display instead of the default display for the object.

MORE INFORMATION
This behavior occurs whether you record the macro using the Microsoft Excel version 4.0 macro language or the Visual Basic macro language. If you use the Microsoft Excel version 4.0 macro language, the recorded macro contains the INSERT.OBJECT function. If you use the Visual Basic language, the recorded macro contains the OLEObject object.

This behavior occurs because the IconFileName, IconIndex, and IconLabel arguments are required in Microsoft Excel for Windows when you use the OLEObject object to insert an object using an icon display. Similarly, the icon_file, icon_number, and icon_label icons are required when you use the INSERT.OBJECT function. These arguments provide information about the icon file to use, the number of the icon in the icon file to use, and the title to use for the icon if you choose to display the object as an icon. However, this information is not required in Microsoft Excel for the Macintosh.

For example, if you turn on the macro recorder, and insert a Microsoft Word 6.0 Document object on your worksheet, using the Display As Icon check box, one of the following commands is recorded:

Visual Basic
ActiveSheet.OLEObjects.Add(ClassType:="Word.Document.6", Link:=False, _

DisplayAsIcon:=True, IconFileName:="Word.Document.6", IconIndex:=0, _ IconLabel:="MS Word 6.0 Document").Activate

Version 4.0 Macro
=INSERT.OBJECT("Word.Document.6",,FALSE,TRUE,"Word.Document.6",0,"MS Word

6.0 Document") In each of these examples, the last three arguments may be omitted, and the code will still insert the object, using a blank icon with no title. Note, however, that these arguments are required in Microsoft Excel for Windows.

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

ARTICLE-ID: Q124311 TITLE    : XL5: GP Fault Using INSERT.OBJECT Without All Arguments