F
Fox via OfficeKB.com
I'm working on an Excel macro which gathers information from various files
(Word, Excel, PowerPoint), as well as email messages. The locations for the
files are passed with variables. I was thinking about adding some error
handling to allow the user to search for and select the file(s) themselves if
the macro can't find the file(s) based on the path and file name passed to it.
I was going to use the Application.GetOpenFilename() method so I would not
have to incorporate any additional library references.
What I would like to know is if there is a similiar method I could use to
allow a user to browse through Outlook folders and select a particular mail
message if the macro can't find the message it needs based on the variables
(outlook folder, subject, attachments,...) passed to it?
(Word, Excel, PowerPoint), as well as email messages. The locations for the
files are passed with variables. I was thinking about adding some error
handling to allow the user to search for and select the file(s) themselves if
the macro can't find the file(s) based on the path and file name passed to it.
I was going to use the Application.GetOpenFilename() method so I would not
have to incorporate any additional library references.
What I would like to know is if there is a similiar method I could use to
allow a user to browse through Outlook folders and select a particular mail
message if the macro can't find the message it needs based on the variables
(outlook folder, subject, attachments,...) passed to it?