Replies

I’m looking for how to go the other way. How do I load an add-in (from a LAN directory)? Schatzie’s code looks to me as if the add-ins are there and that program is looking for a particular one. Would
AddIns(“L:TemplatesTemplateName.dot”).Installed = True
add it?

Andrew, exactly what I wanted to understand. Thanks. And I’m entired pleased with the white lines.

Gary and Crudd, thanks for the suggestions. Since the readers could be people I don’t know, I wanted to avoid depending on a macro (which might cause them to not open the document or to disable the macro), and I couldn’t depend on their having a particular configuration on their computer.

Yes, the white borders do it nicely. Thanks very much. I just tried printing it on yellow paper and I don’t see white borders. That’s nice, but I obviously don’t understand what ‘white’ means.

When you say the formatting is lost, I’m assuming you don’t mean ALL the formatting. As was mentioned, different printer drivers make a big difference, particularly in the number of lines that will fit on a page. And as another poster mentioned, if there’s a font in use that’s not on the other computers, the substitution can make a terrible mess. And if there’s anything in the document that depends on the template, and the template is not available in the location where the document is looking for it, that will affect it as well.

When we’re posting documents to be viewed by others, if formatting is important, we convert them to Acrobat pdf so that the exact formatting will be retained.

This is a wonderful collection of references. Thanks for posting it.

I don’t really know, and I don’t have Word 95, so here’s just a ‘wonder if’: Does Word 95 have any style names with three words, or longer than some number of characters? Is it sort of like DOS names, where the name gets shortened and a number suffix added? Or, does the style have some feature that’s not available in Word95, so it gave it a new name so to indicate that it wasn’t exactly the same?

If you provide templates (saved as .dot files) for the documents people will be doing, and you have the styles all set up in the templates, when people base a new document on the template, the styles will be there. All you’ll need to tell them is the name of the style for the format they want. You can also have a StdDoc or similarly named template that has no boilerplate text at all but has the styles. You just have to train people to start by basing new documents on your standard template.

Edited by wcutler on 01/03/26 20:26.

Tada! Thanks, Jefferson. That fixed the error. After I fixed the code to close the template before activating the new document, it worked.

Edited by wcutler on 01/03/23 00:59.

I didn’t have to configure anything, in the end. I just created the shortcut, renamed it to a short name without a LNK extension so that the DOS name would be similar, and used the DOS name of the shortcut (with the .lnk extension) for the link. I put all the shortcuts in a directory on the web server so they wouldn’t show in Word when people use file|new.

It’s so reassuring to see that Karen has done or is trying to do the same things I’ve been trying to do. I’ve had the problem in Office 97, though, on NT. I’m using Karen’s code to open a new document from a template when the template name is clicked in Word. (I’m using a shortcut to accomplish this from a browser, but it occurred to me I could do both, so a new document would open whether from the browswer or from Word).

I tried Geoff’s suggestion, but it still left the original document (the one with the link) on top. It seems to think the one that’s on top is the current document, so if you save the name of the current document to activate it, that’s the one you get.

I tried Gary’s suggestion to incorporate setting the new object in the add statement, but I specify the template and there’s a compile error – expected end of statement. The statement is:

Set objDocNew = Documents.Add Template:=”J:PROJ-CORTemplateUpdatesProject97ProjectDataelem.dot”, _
NewTemplate:=False

It highlights the word ‘Template’ as the problem. Do you know what I’d need to change?

Phil, I can’t use a solution that depends on a machine setting, as these templates are used by lots of machines on a LAN.

I’m not using Word 2000 here, so this is just an idea. Does it help to save the document after the fields have been filled in? Or even to update all fields, or go into print preview and back? How do people go about making changes to the fields? By right click and update field, or some other way?

I should correct what I said about the shortcut – it’s bad but not that bad. I had to rename the shortcut from ‘Shortcut to abc.dot’ to ‘abc.LNK’. Then I had to use the dos name for that, which you find on the first tab of properties in Explorer. Since the shortcut name was shortened, the dos name for the shortcut begins with the same letters, which is a lot better than having a whole bunch of files with names like ‘shortc~1’.

Thank you jscher. I’m getting there. I found (with some difficulty) the corresponding article for Word 97, which is http://support.microsoft.com/support/kb/ar…s/Q244/2/66.ASP. The setting mentioned in the Word 2000 solution doesn’t exist on my NT/Word97 system. In the Word 97 solution, they said to create a shortcut and link to that, typing in the name. That didn’t work with the ‘Shortcut to abc.dot’ name. I tried to rename the shortcut to something that would be understandable and was short enough to be an acceptable DOS name, but so far, I’ve only got it to work with the real DOS name (SHORTC~4.LNK). But it did work!

What a hassle for maintenance, though. I have copied the shortcut to my C drive, in DOS renamed the shortcut, then copied it back to where I want it on the LAN and that also worked. So really it’s only a hassle for me. No problem.

Thanks, Karen. I’ll look into the Application Object. Word also crashed on me yesterday when I was running the macro. I hope it’s just because I was trying too hard and don’t have things exactly right.

Karen, I’m very excited that you’ve used this on an intranet. In my second post I quoted the error message I got (here it is again: “Add method or property is not available because this document is in another application”). I have it working now in Word (though not from Document_Open – I copied it from there to AutoOpen and then it executed when I linked to it from a Word document), but in our browser, I can sort of understand that it’s trying to open the document in the browser instead of in Word and that must be what it means by “another application”. We use Microsoft Internet Explorer; it sounds as if Netscape handles this ok but MSIE does not. Do you or anyone know how to get MSIE to not integrate with Word and to open the document directly in Word? Or is there some other answer?