Please Help - VBA DAO in EXCEL 7.0 
Author Message
 Please Help - VBA DAO in EXCEL 7.0

Hi;

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?

Thanks

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 for Excel 7.0

2. Using DAO from Excel 95 VBA

3. VB4.0 and DAO for Excel 7.0

4. Need Help with VBA reading Excel using ADO

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. Excel VBA In ActiveX Help

8. Help with Shell command from VBA in Excel

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

10. EXCEL PLEASE HELP PLEASE!

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

12. HELP PLEASE! VBA JET INITIALIZATION ERROR


 
Powered by phpBB® Forum Software