Word app

[zaza]

Hi all,

I'm writing a tool for use in Word, but I'm not sure as to whether I'm going about it in the best way. At the moment, I have it written in VBA (with userforms etc) and I run it from a macro. I've assigned the macro to buttons on the toolbar and put it in the Tools menu, then saved it as a template which I'll put in the Startup folder. It works fine. The problem is that I need to set the macro settings to Low to allow it to run, otherwise I need a certificate. I could make my own and then tell the end-users to Trust it, but I'm not sure that's a very professional thing to do if someone has just bought your software. Alternatively, I could buy a certificate from Verisign (I like it - who says you can't buy trust?) but I don't want to. Is there an alternative way of going about this whole thing?

zaza

[RobDog888]

I think you need to make it a Word Add-In and you may be able to get around
the security level issue. Yes, asking the users to keep the security at Low or
for them to trust it is not very professional and is exposing them to risk.

HTH

[Calibra]

If you are writing for word 97 and older then this is the only way.

If you are writing for word 2000 and younger then you could consider writing an Office COM add-in, check out the MSDN site for information on this subject.
You'l either need Visual C++ 6.0, VB.net (nVB6 is not capable (if i'm correct) or an copy of office developer to create an office com add-in.

With an Com add-in you are not depended on macro's or templates.

[zaza]

Cheers,

Sadly I only have VB.Net Standard, which won't let me make COM add ins.
Oh well.

zaza

[RobDog888]

Oh, if your running .NET 2003 you can always get Visual Studio Tools for Office 2003 (VSTO 2003).
It is an extension of VS where you get a few more options to create a .NET
project on, like an Excel or Word dll project. It makes Office automation a
heck of allot easier and you can take it up a notch with all its new features.
Definately worth the investment if you are doing enough Office projects.

I am running it and I think it a valuable VS.NET tool!

HTH

[zaza]

Ah, good show.

Cheers RobDog

zaza