AnsweredAssumed Answered

Vba, Managing Array : table, database, txt / excel file ?

Question asked by Jerome De San Nicolás on Aug 20, 2018
Latest reply on Aug 20, 2018 by Jerome De San Nicolás



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).