3 Attachment(s)
copy tables from word without repeating header
Attachment 26782Hi Paul, This is Mayur (continuing from stackoverflow) as there is no option to attach files. Hope you are same macropod [IMG]file:///C:/Users/User/AppData/Local/Temp/msohtmlclip1/01/clip_image001.gif[/IMG]
Attached here with are the two invoice files... I am trying to copy the tables (with only header row: with keyword "Description").
Following is the code that i am using. Also wanted to copy Invoice / sales order number with Date and paste in column E.
The instr function is unable to find "Description". Hope you have all the details now. Sorry for the confusion and taking so much time of yours.
copy tables from word without repeating header
[QUOTE=macropod;402740]Cross-posted (and answered before posting here) at:
Yes sir, since there was no option to upload files in stackoverflow :(
copy tables from word without repeating header
[QUOTE=macropod;402751]
Quote:
Originally Posted by
mvakharia
Quite irrelevant. When you joined this forum you agreed to abide by its rules. In any event, as per the line you quoted, the problem was already solved at StackOverflow before you posted here.
Unfortunately still not working as desired and that's the main reason I wanted to share the file. With 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.
Sorry for all the trouble and really appreciate all your help. God bless you!