Opening Excel from Word, first detecting if wrokbook already opened

[gtaborda]

Hi

I've looked in the forum, but I was unable to find an answer.

This is what I am trying to achieve:

From a table in Word, instead of opening a Form to select items, I prefer to open a database in Excel so user ...

1. rightclicks on Word (done)
2. selects new Menu Option called "Open Excel DB" (done)
3. Excel opens
4.Users selects choice (1000's to choose from)
5. Data from the Excel row selected is transfered to Word table
6.Excel hides (doesn't close because it gets used again every few seconds/minutes by user)

Point 1 and 2 is already done.
However opening Excel from Word I have the problem that it opens several instances of Excel everytime I right click+choose "Open Excel DB"...

Anyone could advise on..

1. check with VBA first if Excel file is opened, if so, make it visible OR open Excel file if not opened yet.

2. Easiest way to transfer data from selected cells in excel to Word table cells ?

Your help is most appreciated

 

[SkipVought]

This question would be better addressed in Forum707.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[gtaborda]

ok, I'll do so. sorry