Wait for user to open new file

[bishope]

I need help writing code that will allow the user to open a new file (from an e-mail update) before continuing.

So far I have this:

Please Login or Register  to view this content.

It works fine in break mode, but when I try to run the code, the new workbook doesn't open until after I try to activate it.

Should I put the wait somewhere else?

I know it would be nice to have the workbook saved to a harddrive, but the reality of the situation is... just not going to happen today. Too many hands in one file. So any help with this question would be much appreciated!

Thanks in advance.

[ragulduy]

I would try and approach this by getting the user to open the e-mail, then getting excel to connect to outlook and pick up the attachment as an object, and open it that way.

Please Login or Register  to view this content.

that would get you as far as getting the first attachment of the first open e-mail. I'm not sure how to go about opening it without saving it to the hard drive first though...

[HaHoBe]

Hi, bishope,

maybe use either GetOpenFilename or Application.Dialogs(xlDialogOpen) and set an object to the workbook just opened. This will only work when the file has been saved to any place before, and even the opening of a file from Outlook puts it into a temporary folder on the harddrive.

Ciao,
Holger

[bishope]

Thanks to everyone who replied. I think the easiest solution is to set up an automatic save when the document in question arrives and then it will be more easily accessible.

Sometimes I just need to walk away from the question for an hour before I realize that what I'm trying to do is ridiculous and/or unnecessary.