First, I'm sorry for my english but I need help: I have a file where a macro add some lines, I have another file which is a copy of the first one, but when lines are added to the first one, i want these new lines on the second file when i open the workbook. So i think i have to use Workbook_open and compare both file to copy new lines to the 2nd file but i really don't have any idea how to do it, can someone help me ? Thank you very much for the help!
Asked
Active
Viewed 121 times
0
-
1Can you please share your piece of script, so that we can know your approach. – connecttopawan May 13 '20 at 15:33
-
1I would use the Data, Get Data, From Workbook feature for this, not VBA. – jkpieterse May 13 '20 at 15:33
-
1@connecttopawan i didn't code the workbook_open yet, i don't know how to do – Maxime Ferreira May 13 '20 at 15:39
-
@jkpieterse i don't know that – Maxime Ferreira May 13 '20 at 15:39
-
Is this a 1 time deal or something it'd have to do daily? [this may come in handy](https://stackoverflow.com/questions/19395633/how-to-compare-two-entire-rows-in-a-sheet) – Jimmy Smith May 13 '20 at 15:39
-
1@JimmySmith everytime i open the second workbook – Maxime Ferreira May 13 '20 at 15:41
-
@MaximeFerreira can you post that "macro" as it is? It gives us somewhere to start helping you along – Jimmy Smith May 13 '20 at 16:23
-
@JimmySmith the macros who add lines bro it so much macros there is a lot of files and hundreds of macros, it's for a private company i can't give the file :/ but i just want to compare lines between both and add lines so the second one – Maxime Ferreira May 13 '20 at 16:39
-
I understand you can't give it all, but the small piece of existing macro where you want this code to go? My link should give you a place to start. Also, check this out, https://stackoverflow.com/help/how-to-ask – Jimmy Smith May 13 '20 at 22:35