Import text fields from Word

ALCON,
This is my first post; please excuse my ignorance if I posted in the wrong place...blame it on my age.
BLUF: Bottom Line Up Front, I Import text fields from MS Word forms when they're filed. I have the importing working, but upon running macro to update/import new forms they overwrite my previous data...Example: I import 3 forms, data is place in rows a2, a3, a4 and i save...when i import new forms the data overwrites a3, a4 etc...

This is my code:

Please Login or Register  to view this content.

Any help for this retired veteran would be much appreciative.
Richard

Welcome to the forum!

It is easier to debug code if you indent it for structure. Select and Activate are seldom needed.

try:

Please Login or Register  to view this content.

Mr. Hobson,
I tried your revised code; it ran, but my results were the same. I placed new documents into my unprocessed folder and imported them, the new data started at A3 and overwrote my old data instead of importing the new data on the next empty cell (row).

snb,
when i ran your code I received a bug at line:
Name c00 & c01 As replace(c00 & c01," Un","")

I hope everyone understands my intent: If I place 3 forms in my unprocessed folder, then import them, they need to populate in rows A2, A3, A4. When I place new forms in the folder (4ea), when imported they should be place in rows A5, A6, A7, A8...this is not happening.

Thx for help fellas,
Richard

Your modified code that I first posted worked fine for me. I wonder if you know how UsedRange works? If you count the rows, it can be misleading. Always put some value in row 1 before using UsedRange to count rows unless you know the number of preceding blank rows. Normally, I just count the last row based on the last value in Column A.

This is the same code but a bit easier to set the in and out paths. I commented out the Activate sheet line since I ran it on the activesheet.

Please Login or Register  to view this content.

The code did work; I had forgotten to place a value in A1. Thx for all the help guys...one last question. What do I place in the code to also pull in data from my drop-down list? It's just pulling the text fields...

Again, thx for the help.
Richard

That is what you told it to do with:

Please Login or Register  to view this content.

Look at the help for wdFieldType in Word's VBA and we see:
wdFieldFormDropDown = 83, FormDropDown field.

So, we would change the line of code to:

Please Login or Register  to view this content.