Sally:
I've seen this error before and posted the following "fix" from Microsoft
that solved it the last time. Maybe this will also solve your problem.
XL98: "Error in loading DLL" Opening Workbook with Macros
The information in this article applies to:
Microsoft Excel 98 Macintosh Edition
SYMPTOMS
When you try to open a Microsoft Excel 98 Macintosh Edition workbook or
template that contains Visual Basic for Applications modules, you may
receive the following error message
Error in loading DLL
and you cannot open the workbook.
NOTE: This error message may also appear if the workbook has been created
in Microsoft Excel for the Macintosh, version 5.0, and the workbook
contains module sheets.
CAUSE
You may receive the error message in Excel 98 if either of the following
conditions is true:
The Type Libraries folder is missing from the Extensions folder.
-or-
The files in the Type Libraries folder are the incorrect version or are
corrupted.
RESOLUTION
If the Type Libraries folder is missing, or if the files in the folder are
the wrong version or are corrupted, drag a new copy of this folder from the
Microsoft Office 98 Macintosh Edition compact disc (CD) into the Extensions
folder. To do this, follow these steps:
Quit Microsoft Excel and insert the Microsoft Office 98 CD.
Open the Office Custom Install folder on the root directory of the CD.
Open the Installer Files folder.
If a Type Libraries folder exists in the System Folder:Extensions folder,
drag it to the Desktop.
Drag the Type Libraries folder from the Installer Files folder into the
System Folder:Extensions folder on your hard disk.
Drag the Excel Settings (8) file from the System Folder:Preferences folder
to the desktop.
Restart Microsoft Excel.
You can open the workbook that contains a module without receiving the
error message.
However, if you continue to receive the error message after you complete
the previous steps, follow these steps:
Close any running programs.
Move the following files from the System Folder:Preferences folder to the
Trash:
Office Registration Cache
PPC Registration Database
Start Microsoft Excel.
The first run registration process is run while the Excel splash screen is
displayed. Then, Excel is started.
MORE INFORMATION
The files that are copied to the System Folder:Extensions:Type Libraries
folder when you install Microsoft Office 98 or Excel 98 are listed in the
following table.
File name Version
----------------------------------------
Standard OLE Types (PowerMac) 1.0.2913
Standard OLE Types 2 2.20
Vba en old (PowerMac) 1.0
Additional query words: XL98 vbe vba
Keywords : kberrmsg kbprg kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb
Technology :
-----Original Message-----
From: Sally Bellows [SMTP:sbellows@uclink.berkeley.edu]
Sent: Thursday, June 01, 2000 12:13 PM
To: magnet-list@uclink4.berkeley.edu
Subject: [MAGNet] Excel error loading dll
Dear Magnet -
I've upgraded my desktop G3 to OS 9.0.4 and reinstalled and
upgraded my Office 98 for OS 9. When I try to open a workbook that
had macros, I only get a box labeled "Microsoft Visual Basic" saying
"Error in loading DLL" and the workbook won't open. I can't figure
out what I'm missing.
I never use the old macros I I used to set up those workbooks
anyway, and I deleted them, too, but I still get that "enable
macros?" dialogue box whenever I open the workbook or any copy of the
workbook. Can I get rid of the macro dialogue for good?
Thanks for your help,
Sally Bellows
________________________________
Sally Bellows
Center for Health and Public Policy Studies
University of California, Berkeley
School of Public Health
140 Warren Hall # 7360
Berkeley, CA 94720-7360
phone: (510) 643-1675
fax: (510) 643-2340
http://chpps.berkeley.edu
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about MAGNet, its meetings and events, and its
mailing list, including information on subscribing and unsubscribing,
see the MAGNet Web site at <URL:http://mac.berkeley.edu/help/magnet/>.
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about MAGNet, its meetings and events, and its
mailing list, including information on subscribing and unsubscribing,
see the MAGNet Web site at <URL:http://mac.berkeley.edu/help/magnet/>.
This archive was generated by hypermail 2b29 : Thu Jun 01 2000 - 13:39:45 PDT