ith your revised Instr formula it does go inside the loop but deletes the first row which in case 1 is has two row header.
Also unable to retrieve the Sales Order no. and Date from both the word files.
If you want help, kindly continue the discussion at StackOverflow. I have no intention of carrying on the discussion across two different forums. Thread closed.