Office XP VBA templates & MOSS 2007

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
.

Relevant Pages

  • Re: MS Templates dilemma
    ... One quick way to tell if it's MOSS or WSS would be to open Central Admin & ... I did check in my WSS 3.0 installation and there was no Publishing ... Also the idea that a Publishing tab meant a Publishing template in ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: MOSS Publishing Portal - basic questions
    ... But I do know MOSS is quite difference. ... managemnet system. ... Page Template = a WSS3 term that I'm a bit fuzzy on yet ... So that'd include the master page, content, web parts, etc. ...
    (microsoft.public.sharepoint.portalserver.development)
  • "new sharepoint site" broken after template upload
    ... from my MOSS 2007 Project 2007 Project Web Access site I followed ... steps in this article to create a project workspace template and then ... sites in Moss 2007 when I go to create a new site under PWA (the "new ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Creating Team Sites in Sharepont 2.0 or MOSS for Cities
    ... Basically anything that is possible in WSS 2.0 is going to be possible in MOSS. ... display information and links in the body of the page, alon with a Shared Files Folder and many other links that are on the main computer of each city. ... Is there a way to create a template that will have my links so all I have to do is deploy the template and hand it off to a lay person for them to use. ...
    (microsoft.public.sharepoint.windowsservices)
  • SaveAsTemplate -> stp file -> stsadm.exe -o addtemplate -> create new top level site
    ... I am trying to save the MOSS site as a template, ... Saving the site as a site template (stp file) => Succesful ... When I tried to open the site collection, ...
    (microsoft.public.sharepoint.portalserver)