VBA to open data connected file

[nedley60]

Hi all,

I have a workbook (NXT Daily Update.xlsm) which has got a load of data in it. I have another workbook (CG Daily Update.xlsx) this workbook is made up purely of data connections.

What i would like to do is have a vba macro which when runs closes NXT Daily Update, opens CG Daily update and then refresesh the data connections and saves the file.

Can anyone please help me?

Thanks so much in advance.

Ned