5 Replies Latest reply on Aug 20, 2018 11:04 AM by Jerome De San Nicolás

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

    Jerome De San Nicolás

      Hello,

       

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