J
jamesdeckert
(Using Access 2003. Some computers will use the full version, some the
runtime.)
I'm adding usage of Outlook to my program. However I can't be assured that
all computers which use my program will have Outlook installed.
Therefore what I've done is to do Application.References.AddFromFile Outlook
when the switchboard opens and remove Outlook when the switchboard closes.
This lets me check to see if outlook is available and use it or not. This
seems to compile fine.
The problem comes in when I want to package the program using ADE to make an
MDE file. What causes the making of the MDE to fail is when a line such as
'Dim objOutlook As Outlook.Application' is included in the program. It gives
a "The MDE/ADE could not be created" error.
I've checked that a computer which uses the Access runtime errors on a
missing reference prior to entering the VBA code. Otherwise I could send the
program out and just check for a missing reference and not use Outlook if it
is missing.
Is there a way to make a reference optional and put the code in the program
to use the reference if available, but not require that the computer have
that reference?
thanks for any help or ideas
James
runtime.)
I'm adding usage of Outlook to my program. However I can't be assured that
all computers which use my program will have Outlook installed.
Therefore what I've done is to do Application.References.AddFromFile Outlook
when the switchboard opens and remove Outlook when the switchboard closes.
This lets me check to see if outlook is available and use it or not. This
seems to compile fine.
The problem comes in when I want to package the program using ADE to make an
MDE file. What causes the making of the MDE to fail is when a line such as
'Dim objOutlook As Outlook.Application' is included in the program. It gives
a "The MDE/ADE could not be created" error.
I've checked that a computer which uses the Access runtime errors on a
missing reference prior to entering the VBA code. Otherwise I could send the
program out and just check for a missing reference and not use Outlook if it
is missing.
Is there a way to make a reference optional and put the code in the program
to use the reference if available, but not require that the computer have
that reference?
thanks for any help or ideas
James