Run-time error '13': Type mismatch

[uronmapu]

Dear All,

I have a file, I created two button: Browse and Import

Browsed to file excel and click Import

Error messages below

Run-time error '13': Type mismatch

at code line

Set Rs = CurrentDb.OpenRecordset(tblTabName, dbOpenTable)



Please see attached file and give me advice

http://www.mediafire.com/?05y33dgwm9yakwd
http://www.mediafire.com/view/?ozgs6fhzsfuqk1n

Many thanks

[June7]

How do you declare Rs?

Dim Rs As DAO.Recordset

[uronmapu]

Ok, many thanks June7

Closed