[QUOTE=mvakharia;402752]
Quote Originally Posted by macropod View Post
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.