Are the files stored in the same folder?, does your workbook name remain
constant, the file that is provided to, ddo you have direct conatct to
the person sending it? is it just sent to you?

Al;193593 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=53388