1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help needed

Discussion in 'Business Applications' started by CPJB86, Dec 27, 2012.

Thread Status:
Not open for further replies.
  1. CPJB86

    CPJB86 Thread Starter

    Joined:
    Dec 27, 2012
    Messages:
    2
    Hi All

    I'm fairly new to VBA, so please be gentle.

    I keep getting the error, 'Run time error 91: Object Variable not set' etc. with the following code.

    Can anyone help?

    Thanks in advance

    Code ---

    Sub Button1_Click()
    '
    '
    Dim cmd As ADODB.Command
    Set cnn = New ADODB.Connection
    Set cmd = New ADODB.Command
    Dim rs As ADODB.Recordset

    Dim DSht As Worksheet

    Dim sql As String


    cnn.Open ("~~~")

    UserForm1.Show

    sql = "~~~~"

    cnn.Execute (sql)

    DSht.Range("A8").CopyFromRecordset rs

    cnn.Close

    End Sub

     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1082575

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice