Results 1 to 25 of 25

Export Data from a closed workbook

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    50

    Export Data from a closed workbook

    Good evening/morning forum members,

    I have received a lot of help from the members of this forum for what I'm really grateful. I have come across another issue that someone here might be able to assist me with. In the first attached file I have an empty template that based on the ID number (C1) would automatically populate data from a closed workbook with the same name as in C1 (2nd attached file). So basically here's the workflow:
    1) An ID number is manually input in B1 and C1 creates a label to match the name of the corresponding file that is closed and stored in the directory C:\Users\Desktop\Test\Files
    2)Macro is run and finds the file matching the name in C1 in that file path;
    3)The file (ID_13) gets open and the data gets copied from it (A2:R2200) to Export Data file (E4:V2204);
    4)The ID_13 file gets closed (I don't know if there is a way to not open the file at all-if it's possible it would be even better);
    5) The final extract would look like in Table After Macro is Run tab.

    Please let me know if I need to clarify anything.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Export filtered data into different closed workbook as new worksheet
    By Griffin29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2014, 06:24 AM
  2. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  3. Export Excel data into closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-09-2013, 12:15 AM
  4. Export data from closed workbook to active workbook with ADO connection
    By Naresh27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2013, 01:08 PM
  5. Replies: 12
    Last Post: 07-03-2013, 01:35 PM
  6. How to export data to a closed Workbook
    By newbie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2005, 05:05 AM
  7. [SOLVED] Export data to a closed workbook
    By Luis in forum Excel General
    Replies: 0
    Last Post: 05-21-2005, 09: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