| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste or Change links
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste or Change links
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste or Change links
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" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste or Change links
The code should then go in the senders workbook, so that when you open it it opens your workbook and updates the relevant information.Al;193816 Wrote: 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" wrote: 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' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Copy and Paste or Change links - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=53388) -- 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste or Change links
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" wrote: The code should then go in the senders workbook, so that when you open it it opens your workbook and updates the relevant information.Al;193816 Wrote: 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" wrote: 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' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Copy and Paste or Change links - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=53388) -- 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste or Change links
I understand what your saying but their incremented file is copied from the original, having the code in there will also copy over, everytime 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 to store what the last number workbook opened for update was in order to open the next incremented one in the file....what if a number was skipped?Al;194008 Wrote: 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" wrote: The code should then go in the senders workbook, so that when you open it it opens your workbook and updates the relevant information.Al;193816 Wrote: 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" wrote: 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' ('The Code Cage' ('The Code Cage' (http://www.thecodecage.com))) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' ('The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)) View this thread: 'Copy and Paste or Change links - The Code Cage Forums' ('Copy and Paste or Change links - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=53388)) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Copy and Paste or Change links - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=53388) -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| Paste Special links do not copy right | Excel Worksheet Functions | |||
| Cut/Copy and Paste Functions without old links | Excel Worksheet Functions | |||
| Copy/paste links | Excel Discussion (Misc queries) | |||
| Copy&Paste and Selection Change | Excel Programming | |||
Hybrid Mode
