|
|
#12
10-31-2015, 02:01 AM
|
||||
|
||||
It worked perfect for first sample files I provided.
Please forgive me for providing new sample files as it seems the only solution for now. In my current sample file there are all the elements (or say possible problems). For my current file till raw 4 your code works fine after that when it comes to raw 5 it shows error. I thought error is because US RE44048 is not present in the database 1 file. I don't know what the problem is but it shows I got temporary solution. I recorded macro to remove US [0-9]{5} and US [0-9]{8,11} in a temporary It works fine for now. I Replaced column 3 then with original document. Code:
Run-time Error '91': Object Variable or with block variable not set. I don't have any clue whats going on now. Please find my files at: https://sites.google.com/site/rtsk2015/fo Download: Main.docx Download: Database1.xlsx Last edited by PRA007; 10-31-2015 at 04:40 AM. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to Extract Data from table based on pattern.
|
PRA007 | Word Tables | 4 | 03-17-2015 11:05 PM |
| Retrieving data from data base based on text selection | capitala | PowerPoint | 0 | 12-10-2014 08:10 AM |
|
Inserting text from one word file into another based on an excel input
|
jmaxcy | Excel | 14 | 11-01-2013 04:07 PM |
| Inserting text from one word file into another based on an excel input | jmaxcy | Word | 3 | 11-01-2013 01:26 AM |
| Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode