Results 1 to 2 of 2

GetValues from a Closed Workbook with a conditions/criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile GetValues from a Closed Workbook with a conditions/criteria

    Hi I have this macro working to retrieve/extract/pull data from an Excel closed workbook. The macro pulls the data based on the range but where I am stuck is how to pull an specific account. Lets say the data set has 5 accounts and I want to pull the data for only one account, what is the If logic I can use with GetValuesFromAClosedWorkbook function if any.

    My data set has 5 accounts. I want to pull an specific account lets say P 15178. What the if statment a I need to use in complement with the GetValuesFromAClosedWorkbook function.

    See attached file for the VBA code script.

    Thanks in advance.
    carlos
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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