Opening Outlook and PDF from excell
 

Hi
I am creating a document catalogue in xl, listing documenst of several
types, e.g. xls, doc, msg, pdf etc I have the code to open xls files
from excel, and the code for word dobuments. However a couple three
things I am seeking:

1. Code to open and Outlook Email file from xl.
2. Code to open and Outlook Email file from xl.
3. Word. Currently the code will open a Word document, but it opens
another Word program each time. I am looking for code which will
figure out if Word is already open, and if so, only open the file
requested, not an entire new Word program.


If anyone can help in these items, it would be most appreciated. I
have done a search of the newsgroup and have seen several notes
approximating what I am seeking, but so far, not specifically what I am

seeking.


If anyone can help in these items, it would be most appreciated

Opening Outlook and PDF from excell
 

One way to open various files with the app determined by the file extension
is with the ShellExecute API.
However if you using automation instead, for points listed below:
1. Similar to the method you used for Word
2. Similar to the method you used for Word
3. What makes you think there are multiple instances of Word ?

Post some code of what you have achieved so far.

NickHK

wrote in message
oups.com...
Hi
I am creating a document catalogue in xl, listing documenst of several
types, e.g. xls, doc, msg, pdf etc I have the code to open xls files
from excel, and the code for word dobuments. However a couple three
things I am seeking:

1. Code to open and Outlook Email file from xl.
2. Code to open and Outlook Email file from xl.
3. Word. Currently the code will open a Word document, but it opens
another Word program each time. I am looking for code which will
figure out if Word is already open, and if so, only open the file
requested, not an entire new Word program.


If anyone can help in these items, it would be most appreciated. I
have done a search of the newsgroup and have seen several notes
approximating what I am seeking, but so far, not specifically what I am

seeking.


If anyone can help in these items, it would be most appreciated