Article ID: 182596 - Last Review: October 10, 2006 - Revision: 2.4 XL97: Revised Dao350.dll File for "No current row" ErrorThis article was previously published under Q182596 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.
172322
(http://support.microsoft.com/kb/172322/EN-US/
)
XL97: Run-Time Error 40009 when you Run DAO Macro
The following
file is available for download from the Microsoft Download
Center:Collapse this image  119591
(http://support.microsoft.com/kb/119591/EN-US/
)
How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most
current virus-detection software that was available on the date that the file
was posted. The file is stored on security-enhanced servers that help to
prevent any unauthorized changes to the file.
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: 163435
(http://support.microsoft.com/kb/163435/EN-US/
)
VBA: Programming Resources for Visual Basic for Applications
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
