Hello,
I have a workbook that has data in it provided to me in another Excle file.
The names in my book and the source book are the same. The file is named
myfile_yyyymmdd_z.xlsx. the file is provided to me several times each day
with the z incrementing with each new version. I would like a macro that
would either
copy and paste the new data from the source file to my file There are more
sheets to my file than what is in the file provided to me with links

or more preferably

a macro that when executed would update the links in my file to the most
recent file provided to me.

I am using excel 07


Thanks