Is it possible to change name of the target CSV file for importing without re-creating the entire Connection?

[d0rian]

I currently have my workbook export a simple CSV file named export_X.csv, which I then import into a second workbook (WORKBOOK_2) via the Data...Connections menu. Works properly. However, I want to rename the CSV that gets exported to export_123.csv...every time I've done this in the past, I try to figure out what I need to change in WORKBOOK_2 to essentially tell it: "hey, keep everything the same, but the CSV file to go get and import here is now named export_123.csv instead of export_X.csv...the format / number of rows/cols of the CSV is exactly the same, I just changed the name." But I always give up and end up re-creating an entirely new Connection from scratch. Is there a way to just change the NAME of the CSV I want the connection to find and import?
(Excel 2007, so I don't have PowerQuery)

 

[GraH]

Hi, with the legacy text import feature, you can ask to "prompt for file name on refresh". That way you select another csv file to import. No need to repeat the import steps.

 

[MxJ]

Can't find "Prompt for file name on refresh" in Excel 365.

Any suggestions?

 

[GraH]

Only when using legacy data import. Look in the properties of the data connection.

 

[MxJ]

I only see a Query and nothing in Connections. How do enable legacy data import?

Thanks for your time.

 

[GraH]

You need to customize the ribbon. I believe in the File - Options - Data you can add it. I'm without XL for the moment, I do not always know these things by heart .

 

[MxJ]

I enabled it under File>Options

Thanks