I am using the beta of Microsoft Office 2010 x64. I am trying to write VBA so
a user can control messages with attachments, in particular, to be able to
select messages or an outlook folder and then specify where to save the
attachments. I have managed to put together some code that allows the user to
select a folder and place the attachments in a folder I hard code, but I
haven't been able to gogure out how to give them a dialog where they can
select/create a folder of their choosing. Does such a thing exist in VBA 2010?

Using the Object Browser I found a series of methods in the olObjectClass
called:

olNavigation Folder
olNavigation Folders
olNavigationGroup
olNavigationGroups
olNavigationModule
olNavigationModules

However I can find no information on MSDN or even in the universe of a
Google search. Are these methods that I can use to develop a dialog or is
there something else that can do the job? I realize I could give them a
TextBox to avoid hard coding, but that's hardly elegant.

Any help on creating a file dialog would be appreciated.

---Mike

p.s. I realize I could do this in Visual Studio Express, but then I would
have to make 32 and 64 bit versions, where in VBA the code will work in
whatever version you have.

Those are enumeration members and have nothing to do with file dialogs.

VBA code doesn't really have anything for file dialogs, usually if that was
needed people would make Win32 API calls to work with the common dialog
functions. For only file accesses people use Windows scripting to do
saves/loads/etc.

Outlook VBA is intended for personal macros and prototyping, not deployment.
The recommended approach for deploying code is to write COM addins.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Praising Jesus" wrote in message
...
I am using the beta of Microsoft Office 2010 x64. I am trying to write VBA
so
a user can control messages with attachments, in particular, to be able to
select messages or an outlook folder and then specify where to save the
attachments. I have managed to put together some code that allows the user
to
select a folder and place the attachments in a folder I hard code, but I
haven't been able to gogure out how to give them a dialog where they can
select/create a folder of their choosing. Does such a thing exist in VBA
2010?

Using the Object Browser I found a series of methods in the olObjectClass
called:

olNavigation Folder
olNavigation Folders
olNavigationGroup
olNavigationGroups
olNavigationModule
olNavigationModules

However I can find no information on MSDN or even in the universe of a
Google search. Are these methods that I can use to develop a dialog or is
there something else that can do the job? I realize I could give them a
TextBox to avoid hard coding, but that's hardly elegant.

Any help on creating a file dialog would be appreciated.

---Mike

p.s. I realize I could do this in Visual Studio Express, but then I would
have to make 32 and 64 bit versions, where in VBA the code will work in
whatever version you have.