+ Reply to Thread
Results 1 to 2 of 2

Change ADODB.Recordset by New

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    98

    Change ADODB.Recordset by New

    Help pls change ADODB.Recordset and adodb.connection with New.ADODB.Recordset and New.adodb.connection
    in that code:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Change ADODB.Recordset by New

    Maybe this article can help you with the task. It uses an Excel table and the SUBSTITUTE command to rewrite the command string (record set). Something similar might be able to be done for the connection. http://www.utteraccess.com/wiki/index.php/MS_Query
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Comparing Variant Array to ADODB.Recordset?
    By mc84excel in forum Access Tables & Databases
    Replies: 2
    Last Post: 09-14-2015, 07:29 PM
  2. Refresh ADODB Recordset
    By oteixeira in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-01-2011, 04:12 AM
  3. [SOLVED] ADODB.Recordset from workbooks : numbers only?
    By JVLin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2006, 12:00 AM
  4. writing ADODB recordset to excel sheet
    By bhavesh78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2005, 12:55 PM
  5. [SOLVED] How do I retrieve the column names in a ADODB recordset from MS SQ
    By MChrist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2005, 09:05 AM
  6. problem using isnull() to check a value in ADODB.Recordset
    By tilmP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2005, 04:06 AM
  7. [SOLVED] Delete ADODB Recordset
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1