Replies

Yahoo Mail is doing this too. Your article spurred me to finally go and turn off these updates.

If you have Yahoo Mail and want to prevent people from seeing this kind of information, open Yahoo Mail, then click “Options” followed by “More Options.”

At that point, you can either unmark the “Enable Updates” checkbox and click Save Changes, or click the “Manage who sees my Updates” link and disable updates one at a time.

[indent]

---

Have you tried a two stage Paste Special: one of them is Values; the other is Formats? (You can use the Paint Brush icon for the Formats.) It seems to work for me on Excel 2K.

---

[/indent]Tried that, didn’t work for me…BUT you caused me to re-visit that Paste Special dialog, and I tried something new that did (finally) work:

–In new sheet, right-click a cell and choose Paste Special
–Click the Column widths option and click OK
–Repeat Paste Special but leave All selected

…and that worked just as I wanted it. So thanks for making me go back and look at that again!

Tom

[indent]

---

Have you tried a two stage Paste Special: one of them is Values; the other is Formats? (You can use the Paint Brush icon for the Formats.) It seems to work for me on Excel 2K.

---

[/indent]Tried that, didn’t work for me…BUT you caused me to re-visit that Paste Special dialog, and I tried something new that did (finally) work:

–In new sheet, right-click a cell and choose Paste Special
–Click the Column widths option and click OK
–Repeat Paste Special but leave All selected

…and that worked just as I wanted it. So thanks for making me go back and look at that again!

Tom

[indent]

---

Is there a reason why you can’t Paste Special your selection into a blank workbook and save that? Then copy and Paste Special from this (otherwise meaningless) “special” workbook. All the “exploit” should capture is the rest of the “special” workbook – which should be entirely blank. HTH

---

[/indent]As I mentioned (read the end of my initial post…sorry it’s so long), I did try this. The problem is that it screws up all my formatting, column widths, row heights. I’ll admit that I’m a relative novice with Excel, and if there’s a way to paste cells while retaining those attributes, I simply haven’t found it. However, that would solve my problem, so if someone can point me in that direction I’d be grateful.

[indent]

---

Is there a reason why you can’t Paste Special your selection into a blank workbook and save that? Then copy and Paste Special from this (otherwise meaningless) “special” workbook. All the “exploit” should capture is the rest of the “special” workbook – which should be entirely blank. HTH

---

[/indent]As I mentioned (read the end of my initial post…sorry it’s so long), I did try this. The problem is that it screws up all my formatting, column widths, row heights. I’ll admit that I’m a relative novice with Excel, and if there’s a way to paste cells while retaining those attributes, I simply haven’t found it. However, that would solve my problem, so if someone can point me in that direction I’d be grateful.

My first thought was something along these lines…

Two friends were using their magnetic poetry set on the refrigerator. One asked the other to hand him a “that” magnet, of which there were several. The friend first verifies that he heard the word correctly, and then points to one of the magnets:

“‘That’?”
“‘That.'”
“That ‘that’?”
“That ‘that.'”
“Here you go.”

My first thought was something along these lines…

Two friends were using their magnetic poetry set on the refrigerator. One asked the other to hand him a “that” magnet, of which there were several. The friend first verifies that he heard the word correctly, and then points to one of the magnets:

“‘That’?”
“‘That.'”
“That ‘that’?”
“That ‘that.'”
“Here you go.”

Still learning things…

I figured out that if I click “Yes” when I get the question about a signature, I can continue the process. Then, later, I’ve been choosing “No” when prompted to save changes to what I assume is the IndxrRules01.doc file.

By doing this, I can continue to index different documents without having to fix the rules file again (unless, of course, I want to).

Got it, and have tried it according to your instructions–thanks! It took me a while to get it to work, but I have now successfully indexed every word in a document.

When I first tried it, I modified and re-saved the IndxrRules01.doc file and re-ran the indexing routine, but it did the following two things:

First, it popped up a dialog over a display of the IndxrRules01.doc file that asked “Would you like me to place a signature?” with Yes and No buttons (the title bar of the error said “Utils.dot”).

Then I got a Microsoft Visual Basic Run-time error ‘5153’. The text of that error was:

“Word cannot give a document the same name as an open document. Type a different name for the document you want to save. (C:WINDOWS…STARTUPIndxrRules01.doc)”

I clicked the End button, and it left me in the open IndxrRules01.doc document, except that its title bar said “Document4” and there was another copy of it open in Word with the proper name. I saved the Document4 copy with a different name, closed the other open copy, renamed them both so that the Document4 version was named IndxrRule01.doc, and re-ran the routine, after which it worked fine.

Oh, and I should mention that, just to be contrary, I used a range of 0 to 100 in the first rule, instead of 1 to 999. It worked fine.

Could this behavior have something to do with the fact that Word 2000 opens multiple instances of Word and Word 97 only opens one instance with multiple documents in separate windows? Just a thought.

The document I used for testing is approximately 14,000 words long, and as you can imagine, even with my PC’s 1 GHz processor, it took at least five minutes to create the concordance file. The rest of the process wasn’t too bad, time-wise.

So, thanks! My end result was exactly what I had been asked for…

Thanks for replying. Yes, I’d love to try out any tool you think might help. My VBA skills are quite minimal.

I use WinZip (.zip file extension)…will that open PKZip files? (I successfully opened your Utils.zip download, so I’m guessing I’m OK with WinZip.)

Again, thanks! The e-mail address in my profile would be best.

An old thread, I know, but I haven’t been up on the Lounge in quite a while, and in case someone else ran into this issue, I wanted to pass on our eventual solution.

We fixed it through lots of trial and error, and I’m afraid I still don’t know the exact solution, but here goes:

In Word, choose Acrobat / Change Conversion Settings and click the Office tab.

Unmark any checkboxes you don’t need. (We only keep “Convert Document Info” and “Cross-References and TOC Links” marked, because we don’t really need any of those other features.)

Make the PDF.

That fixed it. In particular, I think it was the new “Embed Tags in PDF” feature that had caused this problem, but since we unmarked a bunch of checkboxes at once and it suddenly worked, I don’t recall whether we ever did sufficient followup testing to determine exactly which checkbox was the culprit.

Hi chrisgreaves,

This sounds like it might be the kind of tool I’m looking for–but the link to your web page doesn’t seem to work. Is there another way to download this?

Background: I’ve been asked to figure out a way to create an index of a Word document that includes EVERY word in the document (I try not to ask why…). I’ve done some exhaustive searching of the Web and haven’t found anything that seems to have this capability, and your indxr sounds like my best chance.

I’m on Win98 using Word 2000, but I could use just about any combination of OS and Office version (big company, lots of PCs).

Actually, there’s not really a way to do what you say, because the object that’s obstructing the text in the PDF is the Word text box that contains the text itself. In Word, such a text box exists as a single entity, including the text it contains, and it only gets separated into “white rectangle” and “bunch o’ text” when distilled to PDF.

So there’s not really a way to make the obstructing object (text box) move behind the text (which is part of the text box)…because it’s just *supposed* to be that way naturally. Acrobat apparently doesn’t see it that way, though…

My latest attempt to resolve the issue had me doing the following: for each affected text box, I ungrouped the box from its accompanying arrow, made sure that both the box and arrow were “In Front of Text” (right-click / Format…), then brought them both to the front (right-click / Order / Bring to Front).

This worked some of the time. It did not work all of the time. And, in a few cases, it caused a nearby text box that previously worked to suddenly stop working.

Frustrating. I’d go on a tirade about my history with Microsoft AND Adobe, but it’s probably not appropriate for this board.

I would post a one-page version of the affected file, but every time I chop this 118-page document down to 1 page, the problem disappears. I can’t duplicate the behavior in a smaller version of the doc.