Templates Misbehaving problem.

[Android]

I'm creating a Word2000 document on a shared drive from
which anyone can launch Word and Excel templates (which I
have
linked to the document).

The problem is:
For Excel or Word, when launched from my document, these
templates don't behave like templates. If you edit and
save the document, it will be re-saved over the template,
as an edited template -- which of course defeats the
whole purpose.

Adding password does hot help because the user is prompted
to save with the same filename in the same folder.

I now know from http://support.microsoft.com/default.aspx?
scid=kb;en-us;278627 that this is a known problem.

Microsoft posts a workaround there, but it does not work.
As per the solution, I create a shortcut and "type in" the
path to the shortcut as the hyperlink (e.g.,
x:\.....\Shortcut to Docname.LNK). However it does not
work - it freezes. If I use the .doc extension, it cannot
access the link.

Has anyone tried this workaround, or have another
solution?

Regards,

Android

 

[Margaret Aldis]

Hi Android

Could you use a macro button instead of a link, and have the macro create
the new document based on the template? (Documents.Add method)

Or perhaps you could use the AutoOpen macro of the template to create a new
document and close the template.

 

[Android]

Thank you for the suggestions.

Tried the 1st suggestion with Word template. Works well.

The second one looks more useful. Trying it now...having
trouble finding the right statement to close the template
file. Any help would be appreciated -- I'm not familiar
enough with VBA yet. Working on it.

Thanks,

Android.

 

[Android]

Margaret,

Your suggestion about "AutoOpen macro of the template to
create a new document and close the template" works with
Word, but with Excel I get a runtime error of 1004
("Cannot find file error" if "run", and "Already Open
error" if "opened").

The code I tried is:

Public Sub Auto_Open()
Dim wkbk As Workbook
Dim WorkbookTemplateName As Workbook

Set wkbk = Workbooks.Add("tplCBA.xlt")
Workbooks("tplCBA.xlt").Activate
ActiveWorkbook.Close
End Sub

I think my code is suspect. Any thoughts.

Android....

 

[Margaret Aldis]

Hi Android

Sorry, can't help with this - try an Excel VBA group?