I can write a procedure to retrieve data from a saved file
which the user can select from a file open menu, but is
there a way to have the user open an attachment to an e-
mail and retrieve the data? How do you pause the
procedure execution while the user searches his/her e-mail
and opens the file? How would you error trap if the user
does not open a file? How can I find the file name of the
opened file? (Is it possible to activate another file
before retrieving the data, thereby,
confusing "ActiveWorkbook"?)

Any help would be greatly appreciated,

Joe

If you use Outlook express you can use this program.

http://www.oehelp.com/DBXtend/Default.aspx

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dick Kusleika" wrote in message ...
Joe

You can't pause the macro for something like that in any meaningful way.
And if you could, it would likely be fraught with problems.

You can, however, automate Outlook to save an attachment programmatically,
read the saved file and delete it. See here

http://www.dicks-clicks.com/excel/ol...%20Attachments

Depending on what you want to do, there are some options. You could list
all the emails with attachments and have the user select the email. Then,
using the code from the above link, save the attachment.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Joe Adams" wrote in message
...
I can write a procedure to retrieve data from a saved file
which the user can select from a file open menu, but is
there a way to have the user open an attachment to an e-
mail and retrieve the data? How do you pause the
procedure execution while the user searches his/her e-mail
and opens the file? How would you error trap if the user
does not open a file? How can I find the file name of the
opened file? (Is it possible to activate another file
before retrieving the data, thereby,
confusing "ActiveWorkbook"?)

Any help would be greatly appreciated,

Joe