+ Reply to Thread
Results 1 to 3 of 3

Macro Not picking up 2016 dates

  1. #1
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Macro Not picking up 2016 dates

    Hi, I have this macro that works great. But now I have files from 2016 and it won't seem to pick them up, it still picks up all the ones from 2015, can you see something in it that may cause this?

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Macro Not picking up 2016 dates

    Has the file name structure changed for your 2016 files?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Re: Macro Not picking up 2016 dates

    Yes, and I couldn't figure it out until you mentioned it. I was looking at the cells within the workbook for something that had changed and it was the Tab name. Thanks for kick starting my brain!

+ 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. Converting Printing/PDF Macro to MAC 2016
    By dquigley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2016, 11:00 AM
  2. picking system date,time with macro
    By thara.p24 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-16-2014, 10:45 AM
  3. [SOLVED] Picking Dates with If/Or
    By imerial in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2014, 04:59 PM
  4. Replies: 4
    Last Post: 04-11-2013, 02:14 PM
  5. If macro picking up 5 inputs changing to 3 outputs
    By andrewg23 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-11-2012, 06:37 PM
  6. Macro not picking up all tables
    By mateoc15 in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2011, 04:17 PM
  7. [SOLVED] Picking every monday from a list of dates
    By Arne Hegefors in forum Excel General
    Replies: 6
    Last Post: 08-03-2006, 11:05 AM

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