I'm trying to accomplish the following in Excel 2003: Intercept the
Save / Save As command and prompt user to enter a string that will be
used to populate one of the document properties. This was easy
enough for any new documents (via Workbook_BeforeSave placed in BOOK.
XLT). However, how can I achieve this for files the user, say,
receives via email from someone else? I came across a post suggesting
Win32 API for a similar task.. Any ideas would be greatly appreciated.