Closed Thread
Results 1 to 2 of 2

Using ADO to pull data from closed workbook.

  1. #1
    abhay_547
    Guest

    Using ADO to pull data from closed workbook.

    Hi All,

    I have two workbooks one is target file.xls and another is source data file. Now I want to pull some data from source data file into target file using ADO method. In my target file in Column A starting from row 3 I have region names like AM, Pacific, Asia, UK etc. and in Column B against the above region I want to populate numbers i.e.. the amount paid to vendors and I have this details in source data file day wise. So now I want to see that on a particular date (which is entered in the cell B2 of target file) how much payment was made to different vendors in each region with the help of macro and at the same time I want a vendor wise amount split as well in column F & G in target file. Here is the code which I got so far.

    Please Login or Register  to view this content.
    I have attached my macro file as well for your reference.

    Thanks a lot for your help in advance.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    315

    Re: Using ADO to pull data from closed workbook.

    Hi

    Do you need to use ADO? It's much easier to link to a (hidden) sheet in your target workbook - see Sheet 2 in the attached Target.xls - and set it so the values update automatically.

    Dion
    Attached Files Attached Files

Closed Thread

Thread Information

Users Browsing this Thread

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

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