+ Reply to Thread
Results 1 to 6 of 6

Open File Based Cells criteria

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,853

    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.

  2. #2
    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?
    多么想要告诉你 我好喜欢你

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,853

    Re: Open File Based Cells criteria

    Hi

    When i run nothing happens!

    Thanks

  4. #4
    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.

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,853

    Re: Open File Based Cells criteria

    Hi Great John, you are great!!!

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


  6. #6
    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 to 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1