Updating the Source of Data Connections with VBA

[olivetwist]

I have a workbook with 3 hidden tabs that store and update data from 3 external CSV files through data connections. The CSV files are appended daily through another process and when my current workbook is opened each day, the data is refreshed and formulas update etc. I am working through an annual process that changes these connections from "file-2016.csv" to "file-2017.csv" and currently do it manually via the Data/Connections menu. I have been unsuccessful in finding a VBA method to update. Is it possible to update the source document for connections via VBA?

 

[narendra]

See if this link helps
Set Excel data connection (csv) with macro - Stack Overflow