Thanks Guys

for this information

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Rob Bovey" wrote in message ...
Hi Ron,

VBA only loads modules into memory as they are required to run your
program. Therefore, as long as you run this code from an Auto_Open procedure
that is located in a module that does not use any objects from the Outlook
type library (not even any declared variables) then this will work. However,
once you discover that a user has Outlook what will you do then? As soon as
VBA loads any model that makes any reference to the Outlook type library you
will get an error. I think you're going to have to convert all of your code
to use late binding in order to do this, either that or use something lower
level like the MAPI API, which is very painful.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Ron de Bruin" wrote in message
...
Hi

I like to ask you something(I hope you don't mind)
Please tell if you don't like that I ask you a question

I am making a new version on this moment off my SendMail Add-in

It will only work with Outlook this version (version 2 will run with OE
also)
because I must send Zip files with it I must use Outlook.
I use Winzip with the Add-on and run it with the shell function
This is working great

But I like to know this

I set a reference in the Add-in to the outlook library in the VBA
If a user with no Outlook installed will open the Add-in he have a
missing reference.

You can use code like yours
http://www.erlandsendata.no/english/...ailableapp.php

Is this working before you get the missing reference error??
I have no machine without Outlook so I can test.
I hope you can tell me??

Thanks in advance


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl