Hi all,
I am running MacroExpress in an Excel file where I have three columns - Department, class, and Item number. The macro copies these values from Excel and looks for the same values in a third-party tool(PRISM) where I have to make some changes for these items(combination of Dept,Class and item number). Now the issue is that if the column 'Dept' has more than 2-digits (for example, 123,345,5679 etc.), then the Macro stops right there and gives an error - saying invalid item combination.
I have tried changing the 'if' condition for the dept from <100 to >=1, and it worked for couple of rows, but later it did not accept 3-digit dept number and instead copied the first 2-digits of the dept.
I have attached the macro so that you people can have a look and re-attach with the changes needed.
Looking forward for a quick and positive reply.
thanks.
Praveen.
Item_Auto_Defective_Flag_ITM380.mex