Replies

What a useful device!!!

Is there any way to add to the code, so that the module will recalculate if the target cell is changed? I played around with it, and it currently could get me into trouble if I had multiple references present, and failed to note that some cells had not been updated.

Well, I “sort of” solved the problem.
–I copied the entire column and then pasted it into Word. Word adds the cell contents as they are viewed, into a table.
–I then went back to Excel and set another (blank) column format as “text”. I put it next to my active date column so I could compare things.
–I then pasted the word table into the new column. I had to choose the proper Paste Special to get everything to enter the way I wanted, but it worked.

I for the most part really like Excel. But this is one of the times that I am willing to make an exception to that “like”.

I have to admit–I was lazy and did not do my homework.:(

I have now done my research and discovered a couple of interesting things:
–Using the style (“Heading 1” for instance) works ONLY if it includes the words at the start of a paragraph. Fortunately, Word considers the content of each cell in a table to be a separate paragraph so it is working for me.
–Using the style method also changes the appearance of the document as the default styles are different from the Normal style. (Of course, the style can be modified). This differs from the default technique for a TOC, which does not affect the document appearance.

If anybody knows how to label text without changing appearance, it would be appreciated.

I did not apply a “style” as such. I just in the past have used the standard menu command to add a TOC reference. The standard command takes the entire paragraph, regardless of cursor position or highlighted text.

I was not aware that the TOC uses a style (although I should have realized it in hindsight). Is there a simple way of adding that style to some highlighted words?

Thanks, and a bit of a Bronx Cheer to Microsoft.

I thought I had stumbled on a wonderful way of shortening the reports that I do. Unfortunately in one the section of the report the paragraph formatting is different from the other section.

Ah well, back to cut & paste.

And thank you for the Fields lesson reference.

I still have one problem, that I cannot find in your reference. Adding the * CHARFORMAT switch did almost everything I wanted, with one exception. Sometimes the bookmarked text is indented using the “Indent” command. This carries over into my REF text.

Indeed, checking with the Paragraph formatting, all the paragraph changes are carried over. Is there a way to tell REF to ignore paragraph formatting?

That did it. Thanks.

[start of rant] But why does Microsoft have to keep dumbing things down? Why? [end of rant]

If you want to keep it as a number, you could also just use a custom number format to display the number in the CAS format: 0-00-0

Steve
PS a shorter alternative formula for generating the text string is:
=REPLACE(REPLACE(E2,LEN(E2),0,”-“),LEN(E2)-2,0,”-“)

PPS. and an even shorter one is not to insert but use the custom format:
=TEXT(E2,”0-00-0”)

That last one is really nice. Thank you.

Hello Eric

Regarding print preview: If you zoom out to show multiple pages, it will show the “non-printing” page. So, if I have three pages in a row, each with the page break odd enabled, zooming out will show five pages.

That said, I will look further and more closely at the documents to see if I can find the information.

EDIT: I have attached two files, one that is problemmatic, and the other that is not.
–The problemmatic one still prints on both sides, regardless of printer. I made it by opening another document, erasing everything, and adding the odd page breaks.
–The other one was created by starting a new document from scratch, and adding the odd page breaks.

Short Answer: Yes.

Longer Answer: I use draft mode as a diagnostic. There I can actually see section breaks and the like. But I do most of my work in normal print mode. And, regardless of which mode I use, the printed results are the same.

And, from either mode, print preview shows the same effect, and printing the product duplicates print mode.

As a note: my templates were created in earlier versions of Word, and I have used Word’s upgrade facility on them to bring them up to the latest version. I should have mentioned this earlier, as I strongly suspect that this problem is a result of initially creating the template in earlier versions of Word.

Thank you. And, I agree about the duplex and business letters. But as I have said elsewhere on this forum, I am but a mere paper pusher who must deal with the in-depth thinking that comes from above.

Nontheless, I will try that suggestion.

I had a similar problem, and I used Excel. I first copied the names into a file using the DOS pipe command (>filename.txt).

I then imported the file (about a thousand names) into Excel, and manipulated it to my needs. I had to sequentially number them, so after I arranged them I used Excel to create a sequential number in an adjacent column.

I then copied the information into another column, using a concatanation technique and the rename command (=”REN”&[appropriate cell]&…….). I copied that column of cells and “pasted special” the values onto a separate sheet and saved that as a text file. I named the file with a “BAT” extension. I ran that batch file, and it really worked quickly and neatly.

I know that this is old, but I wanted to add my two cents.

You CAN add the filename, although it is not automatic. The windows print box has a tab called “Properties” Click on that. Go to “Watermarks”

In the “Edit” box you can add the filename. (If, when you went to open the file you copied the filename, you can simply insert it at this point.)

Then, change the size to (say) 12 point and move it from the center to about -5 inches. That will place it about 1/2 inch from the top. You can drag it to that position.

The default color is a light gray. If you want to edit the color, you can change it to dark black.

(You can save this all by going back to the “Setup” tab, and saving the settings. You will of course have to reenter the filename. To avoid confusion, I made the unedited filename XXXX.)

Now if I could only automate all that it would be nice. I don’t know how to do it with what is on my computer which is really, really locked down. I have only the Microsoft suite to work with.

Word fields have worked that way for as long as they’ve been around (i.e. for over 20 years – i.e. back to when DOS was still around)!

But I was using WordPerfect 5.1 at that time. (And I would still like to be able to use it)

Thanks. That is really weird programming. Who would think that formatting the first character of the field name would be used to define the formatting of the output? And then, only if you tell the field to look at that first character!!

(I am showing my age, but I remember things in DOS, where the switch was applied, followed by the way the switch was to be used.)