+ Reply to Thread
Results 1 to 4 of 4

ADO connection for writing data to excel file

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    ADO connection for writing data to excel file

    Below code copies data from text file to excel (by opening the excel file, pasting data and closing file). I want to replace this process with ADO connection, so it does the process silently. Need help please
    Please Login or Register  to view this content.
    Last edited by Zahid0111; 03-31-2020 at 11:00 AM. Reason: ADO specified

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: ADO connection for writing data to close excel file


    As ADO needs to open the file in order to read or put data and as using the classic easy VBA way
    can be also silent just desactivating the ScreenUpdating property like you can see in the VBA help

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: ADO connection for writing data to close excel file

    @Marc L i have tried to put application.screenupdating = false at the start of code but still i can see during execution file gets open/closed. Can you please help by providing ADO connection for my code

  4. #4
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: ADO connection for writing data to excel file

    Any help please...

+ 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] File dialog box to open a excel file then copy data close file
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2019, 09:57 AM
  2. My Excel SQL connection won't refresh after I close and reopen file
    By Cristian888 in forum Access Tables & Databases
    Replies: 7
    Last Post: 03-29-2017, 08:43 AM
  3. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  4. Activex connection problems, connection jumps if a second Excel file is opened.
    By rdl201 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 09:45 AM
  5. Close connection to text file after import
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-25-2012, 06:13 AM
  6. Excel VBA makes ODBC connection to Access-How do you close the connection?
    By MrHockey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2010, 06:29 PM
  7. Excel 2007 data connection not using connection file
    By algilstrap in forum Excel General
    Replies: 0
    Last Post: 06-09-2009, 03:01 PM

Tags for this Thread

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