Copy and Paste or Change links

  • Thread starter Thread starter Al
  • Start date Start date
A

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
 
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.
 
Their file is created new each time. I would like to save their file and
open my and put the code in my book.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to open file and copy information from worksheet 1
copy and paste data only to a new file 1
Change link-source on file after copy the sheet into new a newworkbook 5
Automated Copy Paste 1
Sub to stack data n paste unique order ID lines 3
Impossible? Dynamic copy/paste 2
Copy and paste in all closed files in a folder 2
Copy and Paste link between workbooks 8

Back
Top