Get File Path by allowing the user to select a file

**Jonathan78** · 04-25-2016, 02:03 AM

Hello all,

Excel provides an option to select files but this seems to be unavailable in outlook.
Is there another option?

The following code allows me to save an email message (with a certain format) to an excel workbook.
However, rather than having the file path hard coded I'd like the user to select an excel workbook for saving.

All help is welcome

Please Login or Register  to view this content.

**cytop** · 04-25-2016, 02:26 AM

Outlook, for whatever reason, may not have the File Picker dialog, but there's nothng to stop you using Excels'.

Please Login or Register  to view this content.

(That example assumes a Reference set to Excel in the Tools/References menu - and cobbled together as an example. You'll have to replace the mso constants are you are Late Binding Excel).