XL97: Revised Dao350.dll File for "No current row" Error

ID: Q182596

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 Download Center. Click the file name below to download the file:

Newdao.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

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