+ Reply to Thread
Results 1 to 3 of 3

Excel Macro to Open last file in last folder, subfolder

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    0

    Question Excel Macro to Open last file in last folder, subfolder

    Hello,



    I need to create a macro that would look on the network drive for the latest year folder (folder name is YYYY, ex: 2016), open, then look for latest period subfolder (folder name P ##, ex: P07), then look for latest week in file name (file name: YYYY Wk ##, ex: 2016 Wk29), then go to cell I5 in "Current Pricing 07-12-16, =VLOOKUP(A5,'[2016 Wk29.xlsx]Wk29'!$1:$1048576,12,0), do this lookup for range A5:A400, and input in I5:I400.



    can you help please.

    Can someone please respond to the above. I'm still hoping for a solution.
    Last edited by MayH; 07-18-2016 at 11:14 AM. Reason: no responses yet

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145
    Hello MayH,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    07-18-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    0

    Re: Excel Macro to Open last file in last folder, subfolder

    thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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