Copy and Paste or Change links

[Al]

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]

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

Hello
I have a workbook that has data in it provided to me in another Excl
file
The names in my book and the source book are the same. The file i
name
myfile_yyyymmdd_z.xlsx. the file is provided to me several times eac
da
with the z incrementing with each new version. I would like a macr
tha
would eithe
copy and paste the new data from the source file to my file There ar
mor
sheets to my file than what is in the file provided to me with link

or more preferabl

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

I am using excel 0


Thank

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Al]

My file name stays the same the other file that I receive is the one that
changes. it is stored in a subfolder of the folder of my file. I do have
contact with the sender (butnot normally), but the file is typically just
sent to me.

 

[Simon Lloyd]

The code should then go in the senders workbook, so that when you ope

My file name stays the same the other file that I receive is the on
tha
changes. it is stored in a subfolder of the folder of my file. I d
hav
contact with the sender (butnot normally), but the file is typicall
jus
sent to me





Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
Forums' (http://www.thecodecage.com/forumz/showthread.php?t=53388

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Al]

Their file is created new each time. I would like to save their file and
open my and put the code in my book.

 

[Simon Lloyd]

I understand what your saying but their incremented file is copied fro
the original, having the code in there will also copy over, everytim
you open the incremented workbook your's will be opened and updated
it's much more difficult to do it the other way as you would have t
store what the last number workbook opened for update was in order t
open the next incremented one in the file....what if a number wa

Their file is created new each time. I would like to save their file an
open my and put the code in my book




Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
Forums' (http://www.thecodecage.com/forumz/showthread.php?t=53388

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Al]

Well I had intended on using the file date/time to determine the appropriate
file. However, I took a sledge hammer to the issue and came up with another
solution. Thanks for your effort