Excel: Opening File from Finder Doesn't Set Directory

ID: Q75608

SUMMARY

If Microsoft Excel for the Macintosh version 3.0 is being used with System 7.0, Excel will not set the active directory to the one where the file is located if the file is opened from the Finder. To avoid this behavior, open the file from within Excel by choosing the Open command from the File menu.

MORE INFORMATION

For a solution to this problem, please contact Product Support directly at 425-635-7080.

The following macro commands provide a workaround to this problem. This macro can be used to set the active folder when a file is double-clicked in order to launch Excel:


+---+-------------------------------------------------------------+
|   |               A                                             |
+---+-------------------------------------------------------------+
| 1 | Auto_Open                                                   |
+---+-------------------------------------------------------------+
| 2 | =ON.WINDOW(,"Set_Directory")                                |
+---+-------------------------------------------------------------+
| 3 | =RETURN()                                                   |
+---+-------------------------------------------------------------+
| 4 |                                                             |
+---+-------------------------------------------------------------+
| 5 | Set_Directory                                               |
+---+-------------------------------------------------------------+
| 6 | =IF(ISERROR(FIND(":",GET.DOCUMENT(2))),GET.DOCUMENT(2)&":", |
|   |  GET.DOCUMENT(2))                                           |
+---+-------------------------------------------------------------+
| 7 | =DIRECTORY(A6)                                 |
+---+-------------------------------------------------------------+
| 8 | =ON.WINDOW()                                                |
+---+-------------------------------------------------------------+
| 9 | =RETURN()                                                   |
+---+-------------------------------------------------------------+

Enter these macro commands on a macro sheet.

Select cell A1, and choose Define Name from the Formula menu.

In the Name box, type auto_open. Click

OK.

Select cell A5, and choose Define Name from the Formula menu.

In the Name box, type Set_Directory.

Click OK.

From the File menu, choose Save As.

Click the Options button.

From the File Format list, select Add-In. Click OK.

For the file's destination, choose the Excel Startup Folder, give

the file a name, and click the Save button.

Additional query words: incorrect wrong application

Keywords :
Version :
Platform :
Issue type :