Results 1 to 3 of 3

Thread: Dynamic source file name change in PowerQuery

  1. #1
    Acolyte albertan's Avatar
    Join Date
    Nov 2017
    Location
    Canada
    Posts
    27
    Articles
    0
    Excel Version
    2013

    Dynamic source file name change in PowerQuery



    Register for a FREE account, and/
    or Log in to avoid these ads!

    For full disclosure I posted a similar thread in MrExcel forum:
    https://www.mrexcel.com/board/thread...query.1177592/

    I appreciate some advice here.
    I have a connection with another csv file but its sheet's name changes every day after it gets replaced with a new extracted file. The sheet name is in this format Data20210721 and it keeps changing every day. So next day it will be Data20210722 after a new extract was done (same folder location) and the old extract will be removed.
    Is there a way for me to make it dynamic to a source sheet (the file name doesn't change as well as location) which keeps on changing?

  2. #2
    Conjurer pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    134
    Articles
    0
    Excel Version
    Office 365
    On my computer, a .csv file has no spreadsheets, just a file name. So I don't have to consider that the name of the spreadsheet changes daily.

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,701
    Articles
    0
    Excel Version
    Office 365 Subscription
    A solution has been provided on Mr Excel.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •