+ Reply to Thread
Results 1 to 3 of 3

Excel Macro to Open last file in last folder, subfolder

  1. 07-15-2016, 09:09 AM #1
    MayH
    MayH is offline
    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
    Reply With QuoteRegister To Reply
  2. 07-15-2016, 09:15 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    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]
    Reply With QuoteRegister To Reply
  3. 07-18-2016, 04:29 AM #3
    kirkmar078
    kirkmar078 is offline
    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 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 code excel list of folder name, the folder path of subfolder, the file name & revision
    By klpw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2015, 04:19 AM
  2. Create multiple excel files into each subfolder with file list from that subfolder
    By foler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:20 AM
  3. Create new folder and subfolder and save file with the names from cell values
    By eccordeiro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2015, 10:03 AM
  4. [SOLVED] Macro to open up a .csv file inside each subfolder in a master folder
    By hutch94 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-05-2014, 07:24 PM
  5. Macro that searches in folder and subfolder - please help
    By anaconte1010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 10:11 AM
  6. Macro to Create Folder\Sub Folder\SubFolder\
    By coolhit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2012, 12:43 PM
  7. Macro to export folder and subfolder names in Excel?
    By Mustang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2010, 09:13 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