Is VBIDE.VBE available in Outlook 2000?

G

Guest

I'm trying to execute the following in Outlook 2000 VBA:

Sub ExportAllVBA()
Dim VBComp As VBIDE.VBComponent
Dim Sfx As String

For Each VBComp In VBE.VBProjects.VBComponents
Select Case VBComp.Type
Case vbext_ct_ClassModule, vbext_ct_Document
Sfx = ".cls"
Case vbext_ct_MSForm
Sfx = ".frm"
Case vbext_ct_StdModule
Sfx = ".bas"
Case Else
Sfx = ""
End Select
If Sfx <> "" Then
VBComp.Export _
Filename:="C:\" & VBComp.Name & Sfx
End If
Next VBComp

End Sub

A reference is set in the VBE to VBA Extensibility 5.3.
SP3 is installed (build 9.0.0.6627).

On execution, VBE is flagged as "Variable not defined".
What is wrong?
 
G

Guest

To the Moderators,
I was directed to managed newsgroups, of which I think this is one, by
my MSDN Universal subscription under the premise that posts would be answered
within 48 hours by someone knowledgeable.
I haven't yet seen a reply to this post.
Am I wording it incorrectly? Or posting where I shouldn't? Or asking
an unsuitable question?
I am in the dark. Could someone reply, please, and set me on the right
course?

Thanks,
Mike Gardner

p.s. Of course, this code snippet is lifted whole from Chip Pearson; did I
make a mistake in not giving attribution to him? Obviously, I didn't lay
claim to it. I'm just trying to autoexport my Outlook solution with a single
click.
 
G

Guest

Thanks, Sue.


Sue Mosher said:
AFAIK, Outlook doesn't support that.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top