R
Rollerboy
Hi,
As the subject line states, I'm totally unable to use the FileDialog
object in a macro/with VBA in Outlook 2002. I've searched the help
files, the Microsoft sites etc., and follows the examples word for word,
but to no avail.
The following code snippets is how the MS staff says it works:
Dim olApp As Application
Dim dlgFile As FileDialog
Set olApp = CreateObject("Outlook.Application")
Set dlgFile = olApp.FileDialog(msoFileDialogFolderPicker)
or
Dim dlgFile As FileDialog
Set dlgFile = Application.FileDialog(msoFileDialogFolderPicker)
But neither of them works! The error message says the Application
object doesn't any such method -- which is completely true.
But the FileDialog object is part of the Office 2002 Shared Library, so
in one way or another it has to be accessible in Outlook as well, hasn't
it? (I've checked that library is loaded/referenced)
So the big questions is, how do I access FileDialog from a module in
Outlook 2002 SP 2? There has to be some other way then opening the
FileDialog via another Office app -- which is the only way I've been
able to do it.
Please bare over me if this is a lame question, but I have used all the
resources which are available for me with my current budget, and saw
this forum as a last resort.
Please post any replies directly to me as e-mail (as well as the group).
Thanks in advance for any help
Grettings from
Rollerboy AKA Øystein, Norway
As the subject line states, I'm totally unable to use the FileDialog
object in a macro/with VBA in Outlook 2002. I've searched the help
files, the Microsoft sites etc., and follows the examples word for word,
but to no avail.
The following code snippets is how the MS staff says it works:
Dim olApp As Application
Dim dlgFile As FileDialog
Set olApp = CreateObject("Outlook.Application")
Set dlgFile = olApp.FileDialog(msoFileDialogFolderPicker)
or
Dim dlgFile As FileDialog
Set dlgFile = Application.FileDialog(msoFileDialogFolderPicker)
But neither of them works! The error message says the Application
object doesn't any such method -- which is completely true.
But the FileDialog object is part of the Office 2002 Shared Library, so
in one way or another it has to be accessible in Outlook as well, hasn't
it? (I've checked that library is loaded/referenced)
So the big questions is, how do I access FileDialog from a module in
Outlook 2002 SP 2? There has to be some other way then opening the
FileDialog via another Office app -- which is the only way I've been
able to do it.
Please bare over me if this is a lame question, but I have used all the
resources which are available for me with my current budget, and saw
this forum as a last resort.
Please post any replies directly to me as e-mail (as well as the group).
Thanks in advance for any help
Grettings from
Rollerboy AKA Øystein, Norway