Excel VBA to reference open word document

Hi....I have code which copies table information from word in to an excel spread sheet....see below....with the current script you have to select the word document but I would like it to pull the information from any word document that is open (this is opened from an e-mail attachment and there will only ever be on word document open at a time). The excel spread sheet where the data is copied to will always be open. How easy or not is this to do? The other alternative could be I that the word document is saved to a temporary file which this script calls.

Please Login or Register  to view this content.

Some guidance would be much appreciated

Rgds



Sharon

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Also,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.