How to paste data from active word file to excel?

[mss90]

Hi,

I have a table in a word file that I wish to copy to excel.

The code below manages to do that task for me, however I wish to change the script so that I dont have to specify where the word file is saved but rather just copy it from an active word window. How do I do that?

Please Login or Register  to view this content.

[Haluk]

Try this;

Please Login or Register  to view this content.