Hi guys,
Ive got a delimited text file which contains several columns, one of which is product code. The product codes are old and need to be changed to the new product codes and file saved as tab delimited before i send the file onto the customer.
I have created an excel sheet (table.xls)which contains all the old product codes in A1-A200 and the new ones next to them in B1-B200.
I have started writing the macro and opened the delimited file into excel and opened up the table.xls. I need to loop through column D of the txt file and find the corresponding entry within A1-A200 then take the value from the next column over and put it into col D of the text file. If the code is not in the range it would put a default value there.
Any ideas please ??
Thanks in advance,
Ive got a delimited text file which contains several columns, one of which is product code. The product codes are old and need to be changed to the new product codes and file saved as tab delimited before i send the file onto the customer.
I have created an excel sheet (table.xls)which contains all the old product codes in A1-A200 and the new ones next to them in B1-B200.
I have started writing the macro and opened the delimited file into excel and opened up the table.xls. I need to loop through column D of the txt file and find the corresponding entry within A1-A200 then take the value from the next column over and put it into col D of the text file. If the code is not in the range it would put a default value there.
Any ideas please ??
Thanks in advance,