K
Kate P
Hi,
In Access, how do I open word docs in order to populate a table (in a db)
with the contents of specific cells, contained in a table in the word docs?
There would be multiple files, of same format, contained in a specific
folder. All docs in that folder will have the contents of specific cells put
into the db table - each doc = 1 record.
* I know how to reference the table & cells etc so skip that bit!
I am not new to programming but am a bit rusty, am new to VBA and never use
word.
Basically what I need is:
1. How to open a number of docs in a specific folder (one at a time)
2. Get the file name
2. Get access to the info inside them (in a general way - I'm assuming I can
set the value of a variable to = the contents of a cell & go from there)
3. Close the file, saving to a different folder.
And if possible:
4. Delete the file from the original location.
*** Don't need to see the word doc. Don't want to have to touch word. Or the
actual files either.
In Access, how do I open word docs in order to populate a table (in a db)
with the contents of specific cells, contained in a table in the word docs?
There would be multiple files, of same format, contained in a specific
folder. All docs in that folder will have the contents of specific cells put
into the db table - each doc = 1 record.
* I know how to reference the table & cells etc so skip that bit!
I am not new to programming but am a bit rusty, am new to VBA and never use
word.
Basically what I need is:
1. How to open a number of docs in a specific folder (one at a time)
2. Get the file name
2. Get access to the info inside them (in a general way - I'm assuming I can
set the value of a variable to = the contents of a cell & go from there)
3. Close the file, saving to a different folder.
And if possible:
4. Delete the file from the original location.
*** Don't need to see the word doc. Don't want to have to touch word. Or the
actual files either.