+ Reply to Thread
Results 1 to 2 of 2

Open Closed Book, carry out a VLookup and then put all entries into blank book

  1. #1
    Registered User
    Join Date
    07-21-2015
    Location
    Aberdeen, England
    MS-Off Ver
    2010
    Posts
    1

    Question Open Closed Book, carry out a VLookup and then put all entries into blank book

    Hi Guys,

    This is my first post.... thanks for the acceptance. I am looking to add to a macro I have already. This reads data in particular cells in Closed books consistently.

    This macro will read a value from I4 from a list of excel spreadsheets and then write the name of the excel spreadsheet with the entry in I4 next to it.

    I would like to look for a value in the closed workbook then read the entire row details into a new book. Looking at the below, the bit I am struggling with is to write a Vlookup function as a substitute for "i4". Is this possible?

    Look forward to hearing back from you.


    Cheers,

    Alex


    This is what I have so far:
    Please Login or Register  to view this content.
    Last edited by vlady; 07-22-2015 at 03:15 AM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Open Closed Book, carry out a VLookup and then put all entries into blank book

    Welcome to the forum AChatwin

    Few reminders:
    Use code tags around codes. Highlight the Code then hit the "#" symbol.
    I've done this one for you.

    Glad to have you with us.
    Thank you.

    Regards,
    Vlady
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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] Copy sheet from closed wkbk to any open book, using VBA that's in personal.xls
    By franklin_m in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2017, 01:23 PM
  2. Replies: 3
    Last Post: 12-27-2012, 12:26 PM
  3. Copy data from closed book
    By cbachu1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2012, 03:31 PM
  4. [SOLVED] Names not deleted until book closed
    By lordfoo@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2006, 02:00 PM
  5. Blank workbook opens when try to open any existing book
    By poloboyUK in forum Excel General
    Replies: 2
    Last Post: 02-02-2006, 04:40 PM
  6. [SOLVED] Copy Worksheet from closed book.
    By Saurjusa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2005, 01:55 PM
  7. [SOLVED] Open book, check for macros, close book
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-31-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1