XL97: Revised Dao350.dll File for "No current row" Error |
The information in this article applies to:
-
Microsoft Excel 97 for Windows
SUMMARY
A revised Dao350.dll file that fixes a problem that may occur when you run
a Visual Basic for Applications macro that uses Data Access Objects (DAO)
is available. When this problem occurs, the following error message
appears:
Run-time error '40009':
No current row.
For additional information about this problem, please see the following
article in the Microsoft Knowledge Base:
Q172322
XL97: Run-Time Error 40009 when you Run DAO Macro
The following file is available for download from the Microsoft
Software Library:
Newdao.exe
For more information about downloading files from the Microsoft Software
Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services
The FTP location is the following:
ftp://ftp.microsoft.com/Softlib/MSLFILES/
MORE INFORMATION
This Dao350.dll file is the same file that is included with Microsoft Excel 97. The version and date of the file have been changed to prevent Microsoft
Visual Basic version 5.0 from replacing Dao350.dll with a newer version
that is not fully compatible with Microsoft Excel 97.
After you install this revised file, you can install Microsoft Visual Basic
or custom Visual Basic applications without having to manually replace the
Dao350.dll file that is included with Microsoft Excel 97 after each
installation.
NOTE: This revised file does not resolve the problem if the recordset
contains a field of type BIGINT.
REFERENCES
For more information about getting help with Visual Basic for Applications,
please see the following article in the Microsoft Knowledge Base:
Q163435
VBA: Programming Resources for Visual Basic for Applications
Additional query words:
Run-time error 40009 vba
Keywords : kbprg kbdta OffVBA xldao KbVBA xlwin
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo
