Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code. I keep getting a type mismatch (run time error
13). Could somebody tell me what I'm doing wrong. Sub Button1_Click() Dim DbRpt As Database Dim RsRpt As Recordset Dim Message As String Dim strSelPh As String Dim strSqlCdRpt As String Dim strOpPath As String strSelPh = Range("E8").Value Range("e17").Value = " " Set DbRpt = _ OpenDatabase("c:\Documents and Settings\c18850\mvsa\rec04\RecRegistration.mdb") MsgBox "Database opened" Set RsRpt = DbRpt.OpenRecordset("combined_ph") MsgBox "Recordset opened" End Sub -- Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
When opening Excel - get Access (Read-Only) file and error | Setting up and Configuration of Excel | |||
In EXCEL, access denied when deleting read only | Excel Discussion (Misc queries) | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
Read / compare MS Access data in excel | Excel Programming |