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)
(Excel 2007, so I don't have PowerQuery)