+ Reply to Thread
Results 1 to 6 of 6

Open File Based Cells criteria

  1. 06-29-2014, 07:10 PM #1
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Open File Based Cells criteria

    Hi
    How to open files based criteria in cells value?
    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  2. 06-29-2014, 09:32 PM #2
    millz
    millz is offline
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Open File Based Cells criteria

    Looks like it should be working fine, except unless you have Option Compare Binary on and your A2 values are not all lower case.

    Is it just doing nothing?
    多么想要告诉你 我好喜欢你
    Reply With QuoteRegister To Reply
  3. 07-01-2014, 09:22 AM #3
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Open File Based Cells criteria

    Hi

    When i run nothing happens!

    Thanks
    Reply With QuoteRegister To Reply
  4. 07-01-2014, 09:36 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Open File Based Cells criteria

    What does this do?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 07-01-2014, 09:50 AM #5
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Open File Based Cells criteria

    Hi Great John, you are great!!!

    Thank you very very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Reply With QuoteRegister To Reply
  6. 07-01-2014, 10:03 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Open File Based Cells criteria

    You're welcome. Glad to help out and thanks for the feedback.
    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. VBA to Open Workbook and VBA to Sum Based on Criteria
    By pitbulluk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-12-2014, 02:58 PM
  2. Open a file based on a counter
    By jnh0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 02:46 AM
  3. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  4. Rename a series of open workbooks as Project1, Project 2 and so on based on a criteria.
    By ishaan198 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-15-2012, 07:06 AM
  5. Macro to open pdf file based on a cell value.
    By martin61 in forum Excel General
    Replies: 0
    Last Post: 12-15-2011, 11:48 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