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:
172322Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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 imageExpand this image
For
additional information about how to download Microsoft Support files, click the
following article number to view the article in the Microsoft Knowledge Base:
119591Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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.
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.
For more information about getting help with Visual Basic
for Applications, please see the following article in the Microsoft Knowledge
Base:
163435Â
(http://kbalertz.com/Feedback.aspx?kbNumber=163435/EN-US/
)
VBA: Programming Resources for Visual Basic for Applications