Please help - VBA DAO for Excel 7.0 
Author Message
 Please help - VBA DAO for Excel 7.0


I am tring to program in Excel 7.0 to retrieve data from an Access 2.0
database.  It seems trivial in the books but when I followed the book
step by step, I got run time error "424": object required.  Could anyone
help me out here?


Meng Li

P.S.  Here is the code I was running:

Sub Sec3()
Dim dbs As Database, rst As Recordset, tbl As TableDef
strFilename = Application.GetOpenFilename(filefilter:="Database Files
(*.mdb), *.mdb; ", filterindex:=1)
Set dbs = OpenDatabase(strFilename)
If strFilename = False Then
    Exit Sub
ElseIf Err Then
    MsgBox "Could not open " & strFilename & "as a database file."
    Exit Sub
End If
End Sub

Sun, 02 Apr 2000 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Please Help - VBA DAO in EXCEL 7.0

2. Using DAO from Excel 95 VBA

3. VB4.0 and DAO for Excel 7.0

4. Excel VBA In ActiveX Help

5. Need Help Manipulating Excel 2000 from Access 2000 using VBA

6. Can Someone please tell me why the Import of Excel Data with DAO Fails

7. Help with Shell command from VBA in Excel

8. Need Help with VBA reading Excel using ADO

9. DAO Field Size Limit Question, Please Please Help.


11. Help this newbie (please) use vba in access!

12. please help, VBA 5.0 newbie

Powered by phpBB® Forum Software