Jump to content
Macro Express Forums

praveen7576

Members
  • Posts

    2
  • Joined

  • Last visited

praveen7576's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Thanks for your response. I have followed your instructions but the macro express isn't responding as required. Please suggest the alternatives. Moreover, it does not copy the 'Class' value from the Excel file and the value for the Item number does not remain same when pasted in PRISM. For example is the Item number is 4567, it takes it as 7645. Thanks! Praveen
  2. 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
×
×
  • Create New...