How do I import a csv file with wild cards

[JeffGrant]

Hi All, and thanks in advance. This a most basic question I am sure.

I have a query which imports a specific file - Main-Report.csv, withthe file path being: C:\Users\...\Input\Main-Report.csv. Which works just fine.

However, when I am back testing, the import file name is Main-Report-dd-mmm-yy.csv

Can somebody please tell me the syntax so that the query will import something like: C:\Users\...\Input\Main-Report*.csv

At the moment, I have having to rename the file and remove the dd-mmm-yy for the query to work. I cant just import all csv files at folder level because there are other csv files in that folder that are not be imported.

cheers

 

[ashish128]

One Solution could be to use file selection window to select the specific file your code needs to act upon. This will save your time and efforts to rename manually

With Application.FileDialog(msoFileDialogFilePicker)
        .InitialFileName = "C:\Users\...\Input\Main-Report*"
        .AllowMultiSelect = False
        .Title = "Please select the Import File"
        If .Show Then ' if OK is pressed
            
            import_file = .SelectedItems(1)
            
        Else
            
            MsgBox ("No File was selected. Now Terminating the execution")
            exit sub
            
        End If
    End With

 

[JeffGrant]

Hi Ashish. Thanks very much for that. I will be certain to give it a go. Whilst you were asnwering I also found this great solution at..

Change the Power Query source based on a cell value

Discover how to change the Power Query source based on a cell value. Amazing technique to build simple solutions for others to use.

exceloffthegrid.com

 

[JeffGrant]

Hi Ashish, just tested and am now using your code to fix another very annoying issue that I had.

Thanks man. Perfect!