+ Reply to Thread
Results 1 to 6 of 6

I need pull the data from closed workbook through assigned path loc

  1. 05-06-2014, 03:51 AM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    I need pull the data from closed workbook through assigned path loc

    Dear Expert

    I want vba help on pulling data from closedworkbook from certain path with range of end column values

    I have two workbook one is Opencall_06-05-2014...File string contains Half today date...I want pull data from Opencall_06-05-2014.xlsb ,Sheename is "Opencall" Paste into Master file...with range of (A:BC).



    Find the attachment of two workbook...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-06-2014, 03:55 AM #2
    akhileshgs
    akhileshgs is offline
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: I need pull the data from closed workbook through assigned path loc

    I have posted a question and there are some macro in that. It is what you are looking for. just change the file names and ranges as per your need
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion
    Reply With QuoteRegister To Reply
  3. 05-06-2014, 05:06 AM #3
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: I need pull the data from closed workbook through assigned path loc

    Sir Can I attachment the file with code On masterbook...Path name where i stored file (C:\Users\mani\Desktop\New folder (5))
    Reply With QuoteRegister To Reply
  4. 05-20-2014, 05:59 AM #4
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: I need pull the data from closed workbook through assigned path loc

    any experts could help on this?
    Reply With QuoteRegister To Reply
  5. 05-20-2014, 06:55 AM #5
    akhileshgs
    akhileshgs is offline
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: I need pull the data from closed workbook through assigned path loc

    The data in the OpenCall is supposed to overwrite the Mater data?
    Reply With QuoteRegister To Reply
  6. 05-21-2014, 07:25 AM #6
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: I need pull the data from closed workbook through assigned path loc

    No Overwrite...clear Old content and copy and paste in to range
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pull data from closed workbook issue
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2014, 11:59 AM
  2. excel userform pull data from closed workbook
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2013, 01:53 PM
  3. Need a Dynamic file path to pull the numbers from different closed excel files
    By vishnu01445 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2012, 11:59 AM
  4. Use VBA to pull data from another closed workbook
    By derryt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2012, 11:09 AM
  5. [SOLVED] Using ADO to pull data from closed workbook.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2010, 06:20 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1