| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Automation error
Where are you pulling the data from...SQL Server, Access?
"Michelle" wrote: Hi Steve, Thanks for getting back to me. No, I never did figure out what was wrong with it. I even stripped it down to nothing! Select * from [Code of Accounts] and STILL couldn't get it to work! Do you have any idea what the syntax would be if I add a variable in an SQL statement? Ex: Set adoRecordset = New ADODB.recordset adoRecordset.Open _ Source:="Select [COAID], [Description] From [Code of Accounts] Where [COAID] = " & SelectedContractNumber & ";" ActiveConnection:=CodeofAccounts, _ CursorType:=adOpenStatic, _ LockType:=adLockReadOnly, _ Options:=adCmdText adoRecordset.MoveFirst "Michelle" wrote: Hi, Thank you for your help in advance. Can you tell me where I'm going wrong with my code? Running Excel 2007 I'm getting an -2147217904 automation error on the recordset.Open line. strSelectedCommodity = Range("EquipmentCommodity").Value 'strSQLCommodityDesc = "SELECT [Code of Accounts].COA, [Code of Accounts].Description FROM [Code of Accounts] WHERE [Code of Accounts].COA= " & strSelectedCommodity & " ;" Set recordset = New ADODB.recordset recordset.CursorType = adOpenStatic recordset.LockType = adLockReadOnly 'recordset.Options = adCmdText recordset.Open strSQLCommodityDesc, UsageTracking |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile error: Automation error in Excel 97 | Excel Programming | |||
| Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
| Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
| Unknown where is the problem on the Runtime error - Automation error | Excel Programming | |||
Threaded Mode
