Search:

Ahh. I see it now. When I first tested, I didn't compile before testing. It was the compile time that caused the 9 to 4.5 second disparity. After compile, both your code and the stuff I wrote runs...

Thanks for responding, guys. Interesting little lesson, here.

I took my work machine home. Wanted to test on the same file. It's got 48 tables, some of them rather long. It's also got a lot of...

Hmmm. I ran the following code.

<pre>For j = ActiveDocument.Tables.Count To 1 Step -1
sngWid = 6.5 / ActiveDocument.Tables(j).Columns.Count
For i = 1 To...

Hi Arild,

When you attach a new template, styles don't automatically come over. Use the Organizer (Format>Styles>Organizer Button) to copy the styles from your template to the document..

HTH,
...

I tried from Outlook. The only mail merge I could find was using Contacts. I wanted to use an external data source. In fact, Outlook help leads you in the direction of using Word's mail merge. Still...

Anybody know of any decent workarounds to the problem of not being able to mail merge a protected form? We had to do this programmatically.

Heaven forfend that one would want to email a survey.
...

Hi Ron,

How about creating another heading style ("Heading 2 w/ Page Break") and setting the Page Break Before property?

HTH,

Chris

Hi Kevin,

How about this?

The following code operates (sort of) on the HTML files of a Help Project. It works fine if run stand-alone. When called as a sub, it does not work in run-time, but does work if I break at the msgbox...

Hi Howard,

I'm aware of that. Perhaps I was unclear. My point was that you could use FileSearch to open only files with a .doc extension and a file type of template, eliminating the need to open...

Or, use FileSearch to open the docs and set .FileName to "*.doc" and .FileType to msoFileTypeTemplates. That should target the offending files pretty well.

HTH,

Chris

Garrrrhhh. Two problems

1). It worked fine last week, honest. The code checks documents into SourceSafe. It sets a document variable to the document to be checked in and a variable to a dummy doc...

Oop. I forgot it needs to work on a selection...

Aha! Now we're gettin' somewhere. Why use a dummy doc at all?

<pre>ActiveDocument.Styles("Testing").Delete
ActiveDocument.Styles.Add Name:="Testing", Type:=wdStyleTypeCharacter
With...

Hi Lin,

I agree. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> That's why I said in the last post, "The replace with new character style seems much better. "

I proposed the code...

All I could think of off-hand was brute force. The replace with new character style seems much better.

But, if you're interested, here's a snippet. You'd have to read into the array the font...

I'm confused. You *don't* want to remove text with the character style from the document.

Do you want to undo the character style without impacting manual formatting on other text in the...

Instruct users on how to (or create a macro to) use Find/Replace to replace style "Instructions" with nothing.

HTH,

Chris

Hi Daniel,

You might want to grab the install root value from the registry and append it to your shell string. For Office 97, I believe it's...

Hi Joanne,

How about the following?

<pre>Dim strSQL As String


strSQL = InputBox("Please enter the number of the month to use.", "Month")
strSQL = "SELECT * 2001TIME.xls WHERE...

Hi Klaus,

Open the original template and do a Save As from there, not from a document based on the template.

HTH,

Chris

Hi Mark,

The version of VBA in Work 2k added the Replace function. The following replaces all instances of two spaces with one. You may need to iterate through it several times if you're concerned...

Hi MelanieB,

If you show field codes, you can run your find and replace on the hyperlinks. Go to Tools > Options > View Tab > turn Field Codes on.

HTH,

Chris

Rather than a macro, what about setting up your users spellchecking to enforce this convention? Tools > Options > Spelling and Grammar > Settings > Spaces Required Between Sentences.

Chris

<P ID="edit" class=small>Edited by Chris Green on 18-Oct-01 14:30.</P>Ahhh. Well, I don't call it "Workaround" for nothing. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> Here's a...