Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to assign the following code to a button on my Excel 2003 spreadsheet.
When I click the button, I receive a Microsoft Visual Basic Error "Compile Error: User-defined type not defined" Dim Con As New ADODB.Connection Dim Cmd As New ADODB.Command Dim Cmd2 As New ADODB.Command Dim Rs As ADODB.Recordset Con.Open "DSN=KIAMOTOR;" Set Cmd.ActiveConnection = Con Cmd.CommandText = "SELECT * FROM PTFGRPP" Thanks in advance for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can't I click the Subtotal button? | Excel Worksheet Functions | |||
further options following a command button click | Excel Discussion (Misc queries) | |||
Name of Text-Box Right-Click Command Bar? | Excel Discussion (Misc queries) | |||
Is there any way to have a maco click a command button | Excel Discussion (Misc queries) | |||
Linking one worksheet to another by click on a command button | Excel Discussion (Misc queries) |