How to create an Add-In

  • Thread starter Thread starter Jonas
  • Start date Start date
J

Jonas

Hi,

acutally I know how to write Outlook Macros with VBA, but how can I create
an Add-In with an trustworthy certificate ?

Thanks.

Regards,

Jonas
 
I just want to have an Outlook macro that can be installed by any kind of
setup.
And moreover it should can be run in contrast to any other macro that is not
trustworthy.
I want to make sure that this macros works, without confirmation on startup.

The macro should start when new emails arrive. Therefore it's linked to the
internal app events.
It's written in VBA and I have no idea how to compile it and have a
installtion around it.

Thanks.

Regards,

Jonas

Ken Slovak - said:
Certificates have nothing to do with COM addins or trusted COM addins.
I sign my COM addins with a code signing certificate but that doesn't
affect COM addin security at all. What exactly are you trying to do?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm


Jonas said:
Hi,

acutally I know how to write Outlook Macros with VBA, but how can I create
an Add-In with an trustworthy certificate ?

Thanks.

Regards,

Jonas
Click to expand...
Click to expand...
 
All Outlook macros are kept in one file, VBAProject.OTM. You cannot
have a signed macro and another one unsigned. You either sign the VBA
project or you don't. You can export modules that have macros in them
and the user can import those .BAS files. Or you can distribute an
entire .OTM file, which would overwrite any previous .OTM the user
had.

Signing a VBA project is something the user has to do with a
certificate that is valid on their computer. That can be a commercial
code signing certificate from an authority such as Thawte or Verisign
or it can be the free certificate generator included in Office
(SelfCert.EXE). If the certificate is installed on the user's computer
they can install it in the VBA project using the Tools, Digital
Signature menu and then trust the certificate in the UI from Tools,
Macros, Security. That menu also lets you set macro security to High,
Medium or Low.

The best way to distribute code is to develop a COM addin and
distribute that.

I'd suggest starting at http://www.slipstick.com/dev/index.htm and
looking at the topics for VBA and COM addins to get a handle on all
this.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 
Back
Top