After I hit Send, I thought about putting some code into Word's
Normal.dot template.

In Excel, you can set up application events, and capture the opening of
a new file with the WorkbookOpen application event. Then if the filename
ends in something other than ".xls" you could close the file and give
the user a nasty warning.

Word (97, anyway, which is what I have here in the office) does not
offer a DocumentOpen application level event that would close all non
".doc" files. So unless anyone else here has an idea, I think you just
need to keep good backups and start beating up your users.

You might try posting to one of the Word newsgroups....

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Jon Peltier wrote:

Sounds like your users need a little training. I don't think the Excel
WorkBook_Open procedure would even fire if the workbook is opened in Word.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

VBA Novice wrote:

They start Word and then open the workbook from inside Word. Seems to
me there should be someway to tell the workbook to check to see which
application is opening it and not open if it is not Excel.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!