OFF95: Forcing Office Shortcuts into a Subgroup

- Microsoft Office for Windows 95, version 7.0

SUMMARY

This article explains how you can force the Microsoft Office 7.0 Setup program to create shortcuts for the various Microsoft Office applications in a subgroup of the Start menu, rather than directly in the Start menu itself.

MORE INFORMATION

When you install Microsoft Office for Windows 95, version 7.0, the Setup program creates shortcuts for the various Microsoft Office applications directly in the Start menu. This behavior is different from that used in earlier versions of Microsoft Office; in earlier versions, icons for the applications are created in a separate group in Program Manager.

For example, the default hierarchy used by Microsoft Office 7.0 is as follows:

   Programs                       <-- main level
      Microsoft Excel             <-- application shortcut
      Microsoft Word
      Microsoft PowerPoint
      Microsoft Access
      Microsoft Schedule+
      Microsoft Binder

   Program Manager                <-- main level
      Microsoft Office            <-- program group
         Microsoft Excel          <-- program icon
         Microsoft Word
         Microsoft PowerPoint
         Microsoft Access

   Programs                       <-- main level
      Microsoft Office 95         <-- menu subgroup
         Microsoft Excel          <-- application shortcut
         Microsoft Word
         Microsoft PowerPoint
         Microsoft Access
         Microsoft Schedule+
         Microsoft Binder

WARNING: This modification may not be supported by Microsoft Product Support Services (PSS). PSS will support some modifications to a BACKUP copy of the SETUP.STF file. Note also that while PSS may help customers modify specific lines of an STF, we will not rewrite the entire file in order to achieve a desired configuration. As a general rule, support is limited to options that can normally be changed by a user during a standard installation of the application.

For more information about customizing the location of the Office shortcuts on the Start menu after installing Microsoft Office, please see the following article in the Microsoft Knowledge Base:

   ARTICLE ID: Q132979
   TITLE     : OFF95: Customizing Start Menu to Create Microsoft Office Menu

Opening and Saving the STF File

NOTE: Do NOT make changes to the original SETUP.STF file. Before making any modifications to an STF file, make a copy of the file and modify the copy.

After you have made a copy of the STF file, you can open the copy of the STF file in Microsoft Excel by following these steps:

1. In Microsoft Excel, click the Open on the File menu, and open the STF file that you want to modify.

2. In the Text Import Wizard dialog box, click the Next button repeatedly until "Step 3 of 3" appears.

3. In the Text Import Wizard - Step 3 Of 3 dialog box, scroll the Data Preview box until the word "ObjId" appears in the first column.

4. Hold down the SHIFT key on your keyboard.

5. Use the scroll bar to scroll the Data Preview window as far to the right as is possible. You should see the words "Install Directory" in the rightmost column.

6. Click once on the last column. All of the columns should be highlighted.

7. Under Column Data Format, click the Text option. Click Finish.

1. Select the entire worksheet by pressing CTRL+SHIFT+SPACEBAR.

2. On the Format menu, click Column, and then click Column AutoFit Selection.

3. On the File menu, click Save As.

4. In the Save As dialog box, make sure that the Save As Type box contains the Text (Tab Delimited) item . The name of the file should NOT be "Setup.stf." If it is, change it to a different name that ends with the ".stf" extension .

5. To save the file, click Save or OK.

6. On the File menu, click Close to close the STF file. If you are prompted to save the file, click the No button.

   Setup /T N:\Office\Custom.stf

Manual Modification of the STF File

In the Microsoft Office 7.0 (Standard Edition) STF file, the following ObjIDs control the location of the following application shortcuts.

   ObjID   Application Shortcut            Destination (Column K)
   --------------------------------------------------------------
   862     Microsoft Binder                %860,%d
   1454    Microsoft Word                  %1452,%d
   3152    Microsoft Excel                 %3150,%d
   5102    Microsoft Schedule+             %5098,%d
   6268    Microsoft Office Shortcut Bar   %6258,%d
   7658    Microsoft PowerPoint            %7656,%d

   6280    New Office Document             %6260
   6284    Open Office Document            %6260

By changing the value in the Destination column (column K), you can change the location where the shortcut will be created. The first part of the destination (preceding the comma) determines where the shortcut will be created. You can add additional pathing to the values, changing the locations that they refer to.

For example, to create the Microsoft Binder shortcut in a subgroup called "Microsoft Office 95," you would change the value in column K from

   %860,%d

   %860\Microsoft Office 95,%d

To install ALL of the shortcuts listed above into a separate subgroup ("Microsoft Office 95", for example) under the Programs menu, make the following changes to the values in column K:

   ObjID   Destination
   ------------------------------------
   862     %860\Microsoft Office 95,%d
   1454    %1452\Microsoft Office 95,%d
   3152    %3150\Microsoft Office 95,%d
   5102    %5098\Microsoft Office 95,%d
   6268    %6258\Microsoft Office 95,%d
   6280    %860\Microsoft Office 95
   6284    %860\Microsoft Office 95
   7658    %7656\Microsoft Office 95,%d

After you have modified the STF file, save the file by following the steps in the "Opening and Saving an STF File" section above.

Automated Modification of the STF File

You can use the following Visual Basic, Applications Edition, macro to make the necessary modifications to the values in column K of the STF file.

NOTE: This macro is designed to work with the STF file used by Microsoft Office version 7.0 for Windows 95, Standard Edition. If you are using a different version of Microsoft Office 7.0 (the Professional Edition, for example), you will need to use different values in the ItemArray variable used in this macro.

Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.

   Sub ModifyOffice7STF()

      'The values contained in the "ItemArray =" line are specific to
      'the STF file used by Microsoft Office 7.0, Standard Edition. You
      'may need to use different values if you are using a different
      'version of Microsoft Office.
      '
      'If you also want to relocate the New Office Document and Open
      'Office Document shortcuts to the new subgroup, use this line of
      'code instead:
      '
      '   ItemArray = Array(860, 1452, 3150, 5098, 6258, 7656, 6260)
      '
      ItemArray = Array(860, 1452, 3150, 5098, 6258, 7656)

      'Modify this line to contain the desired name of your subgroup.
      SubgroupName = "Microsoft Office 95"

      'Start the loop.
      For X = 0 To UBound(ItemArray, 1)

         'Set the StatusBar so that we can see what's happening.
         Application.StatusBar = "Changing Object ID " & _
            ItemArray(X) & "..."

         'Select a range large enough to contain the entire STF file.
         Range("A1:M10000").Select

         'Change the value in the Destination column.
         Selection.Replace What:="%" & ItemArray(X), _
            Replacement:="%" & ItemArray(0) & "\" & SubgroupName

      Next X

      'Reset the StatusBar.
      Application.StatusBar = False

   End Sub

1. On a new module sheet in Microsoft Excel, enter the macro above.

2. Open the STF file, following the steps shown in the "Opening and Saving an STF File" section above.

3. With the STF file active, click Macro on the Tools menu.

4. In the list of macros in the Macro dialog box, click ModifyOffice7STF. Click Run.

5. After you run the macro, (the status bar should display the text "Ready"), save and close the STF file, using the steps in the "Opening and Saving an STF File" section above.