Hi VBA Gurus,

Thanks in advance for your constant advice on several VBA problems we readers have all the time.

I have a strange situation to be sorted using VBA. Not very sure if I can do that. It is like this:

I am currently working on an Excel Application with Access as the database. Everything is going on fine, until I came across one requirement where some data should be fetched from the database and filled into a Word document which acts as a job-aid for that specific task. It is a big document which has one specific table where some data should be inserted in one column. Rest of the job will be taken care by the operator in concern.

Initially I planned to re-create that word doc as an excel file which will ease my job. But from a usability point of view and in terms of future (where the document will have several changes), it is not an ideal solution. So I thought I'll shoot out a question with you guys before I take a major step and invest my time.

To sum up - I need to fetch some info from Access using Excel VBA and insert it into a Table in the 2nd page of a word document (if possible save it in a different name in the same folder )

Please let me know your suggestions, if this can be done. More helpful if you can guide me to some snippets of sample code, I'll play it and try to get the job done.

Thanks in advance,

cheers,
Ravi.