Office XP VBA templates & MOSS 2007

J

jo

Help! I need some direction!

My organization has several very complex Word XP templates that need
to be accessible from MOSS 2007.

The main template actually references six other templates (broken up
due to size limitations). I would like to be able to access my
templates from MOSS 2007 - Here's a outline of what we're doing now...

1. Word template - on open runs autoexec macro which displays a user
form. This form allows the user the create a new document or revise
an existing document created with the template.

2. The template is very restrictive in its formatting and content -
on save of the document, most formatting is stripped out and the
document is formatted to legal requirements (Draft Legislation - A
Bill for Resolution for a State Legislature)

3. Upon save, the document is password protected so the user must use
the template interface to open it later. This prevents the user from
opening the document in Word outside of my "protected" environment.

What is the best way to make these documents available to the user via
a Sharepoint Dashboard?

1. I would like for the user to be able to create a document from
their dashboard by clicking on a link that will fire the word template
we are currently using.

2. I would also like for the user to be able to revise this document
by clicking on the filename link but I still would like it to be
available only within my protected environment.

I realize that I cannot use VSTO since my projects are in Office XP.
I am using Visual Studio 2005....

Should I create a .Net project to call my VBA Code or should my VBA
code call a .NET project?

I am at a total loss as to the best way to approach this.....

Converting from Office XP to Office 2007 is something we are planning
to do - but at this point, I have to make due with what we have....
Any suggestions?

Thanks
 

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