con

Greetings I am trying to extract data from SQL Server using Excel VBA. Below is the code which errors out @ the Rs.Open StrSQL, Con Sub DbConnection() Dim Con As ADODB.Connection Dim Rs As ADODB.Recordset Dim Fld As ADODB.Field Dim StrSQL As String Dim Wb As ThisWorkbook Dim Ws As Worksheet...

En una hoja1 tengo unos datos de apoyo, en A1, A2 y A3 los títulos; y en B1, B2 y B3, las cantidades. En la hoja2 unas operaciones con fórmulas. Quiero conseguir lo siguiente: En A1 (hoja2), mediante una fórmula que me incluya el título que se encuentra en A1 (hoja1), pero con las siguientes...

I'm trying to update MULTIPLE records (field "category" = "PAINT") when another field (description) contains word "paint", in access record through Excel VBA. Below code doesn't through any error. But no data is updating. The sql statement is working fine when I check in directly on Access...

Hi All, I have successfully connected excel to SQL developer using the below VBA code. I have oracle client and oracle dc drive in my machine. Dim con As ADODB.connection Dim rs As ADODB.Recordset Dim Cmd As New ADODB.Command Dim query As String Dim strsql As String Dim a As Integer 'Dim db...

For example, I have following string <tbody> SPLICE 3_CON 195_INTERLOCK_18_BROWN I am trying to write VBA code to split it into five and put in different columns like: <tbody> SPLICE 3 CON 195 INTERLOCK 18 BROWN </tbody> </tbody> Any help is appreciated.

Hello... I have the following code in my Excel VBE attached to a button that when clicked runs a query in Access then places the results into an Excel sheet It works perfectly, but only so far as I hard code the date of the data I want returned in the Access query. Naturally, I need the query...

Hello... I have the following code in my Excel VBE attached to a button that when clicked runs a query in Access then places the results into an Excel sheet It works perfectly, but only so far as I hard code the date of the data I want returned in the Access query. Naturally, I need the query...

Hello all, I have a coding solution that worked successfully for a number of months but then stopped. I'm self-taught / Google/Youtube taught so you may have to dumb it down for me. The code takes a few fields from Excel and writes it to a SharePoint list. The code still works fine for me and...

Hello all, I need some help from you to translate VB.NET code to VBA. This is the code I would like to have help with: Dim con As New OleDb.OleDbConnection Dim com As New OleDb.OleDbCommand Dim dr As Data.OleDb.OleDbDataReader con.Open() com.Connection...