I am working on a macro to replace components in an assembly (tanks to a new library), I do not have any problem for the code (for now !).
I wonder what's the best practice to manage the data, actually, I have a large (about 1150 refs) excel file of the old part number and the new one, a little bit like this :
Old No New No Path Config
Old123 New456 C:/.. M10x010
ect.... +1150 lines
I need this data in my macro but what is the best way to do it?
I was thinking of a text file, so I can add line to it (in case of a new part to replace). When do i put the data into my variables ? Can I read and search a txt file and only take the line that is needed? Or do I make an Array_Of_Doom with all my txt file in it?
Bref, how do you guy'll handle such a problem?
Thanks (I hope that I've been clear enough).