Replies

Arrghh, right, the Application.LanguageSettings object seems to be new in Excel 2K.
I just checked the Excel 97 Visual Basic Help and it is not there.
Now, I hope someone else has a new idea …
Doris

Hi Erik Jan,
you could try the Application.LanguageSettings Object. I found the following macro in the Visual Basic Help and run it on my Excel to determine the language:

Sub LanguageTest()
MsgBox “The following locale IDs are registered ” & _
“for this application: Install Language – ” & _
Application.LanguageSettings.LanguageID(msoLanguageIDInstall) & _
” User Interface Language – ” & _
Application.LanguageSettings.LanguageID(msoLanguageIDUI) & _
” Help Language – ” & _
Application.LanguageSettings.LanguageID(msoLanguageIDHelp)
End Sub

The result is 1031, which seems to be the code for German.
I don’t know whether it is the Install Language, msoLanguageIDInstall, which counts in your case, or the User Interface Language, msoLanguageIDUI.
Doris

Hi Andrew,
the way I understood the problem, it was required that the conditional formatting checks the cell to the right of the active cell (in case of L4 that would be M4) to see whether it is larger than 8.
On my system, the code: Formula1:=”=ZS(1)>=8″ does exactly this: applied to L4, it produces in the Conditional Formatting check box a: =M4>=8.
ZS(-1) would check the cell to the left, K4, ZS the cell itself, L4.
Square brackets, ZS[1], are not accepted and produce an error: “05 Invalid procedure call or invalid argument”.
Doris

I don’t think that you are doing something wrong.
Meeting requests sent as plain text get converted to attachments.
BTW, what’s wrong with RTF for internal mail?
Doris

On my German system, the following code (recorded) works fine:

.FormatConditions.Add Type:=xlExpression, Formula1:=”=ZS(1)>8″

You can use the RC notation in code on German systems, I have done that before. But I think, in this combination (with Formula1 and quotations), Excel expects the formula to be written exactly as it would be entered into a local Excel version’s worksheet cell. Which is, in the case of German, not RC but ZS – Z for Zeile (row) and S for Spalte (column).

Doris

It depends on what sort of file you import. If it is a text file, there is not much of a interface to set up. Just select the file. Then, in the query-by-example window drag the column headers and, if necessary, specify criteria. Exit and return with the data to Excel.
The setup process is more complex, but still straightforward, if you import from Access or another database application: Dialogs where you have to specify datasource, ODBC driver .. but finally the same query-by-example window.
Doris

I experimented a little with keys and I found that it is the Alt-key which overrides the “select entire word”. Thank you for the suggestion. But as you said, it is probably even better to use the keyboard for this type of selection.

You could try Microsoft Query (Data / External Data / New Query). With this tool, you create queries on comma separated Text files, very much in the Access query style. Queries are especially useful, when you want to select data columns or data rows.
As far as I know, you cannot change formats, data are imported the way they are (there, the text import assistant is better) and queries do not work with fixed width data.

Doris

Thanks a lot, this works.

Actually, I had seen thisoption before. But I left it unchecked because I thought its sole purpose was to select whole words when a selection starts in the middle of a word and continues beyond it.
I don’t like this feature, because most of the time, I write in German, and very often I have to change a word’s ending when I change the following word(s). The easiest way to do this is to select the ending and the following word(s) and overwrite the whole selection. With “When selecting, automatically select entire word”, I can no longer work this way.

It seems that Word 2K makes me choose between a nuisance and another one.
Thank you for your prompt response.
Doris

Hi Dave,
I am not quite sure, whether I got your problem right. But maybe you should try the following:

Bring up the folder list. There, right-click on one of the contact folders that causes trouble. Choose “Properties” from the pop-up menu and go to the “Outlook Adress Book” tab. There, activate the “Show this folder as Outlook address book” checkbox. Repeat the procedure for the other contact folder(s).

Only the contact folders which have this checkbox checked appear as address books when you hit the To-button in a new email message.

Doris

Funny thing, I used to think that you could simply select the whole list and copy and paste it to Excel for sorting, printing etc…
But I end up with the same, semi-colon separated names list as you do.
As a last resort, have you tried a screenshot?
Alt + Print, then paste it to Word and use crop picture to trim it to the right size?
Doris

Can’t you see that in the adress book listing?
When I click the To-button to bring up the adress book, my entries show what type they are, for ex.,
John Smith (E-Mail)
John Smith (E-Mail 2)
John Smith (Business Fax), etc.

Doris

If not a solution, so I found at least an explanation: The bug seems to be in Format / Replace Font and seems to be restricted to Powerpoint 97. There, use Replace Font to change Times Roman into Arial, and end up with the funny phenomenon that copy and paste (within that presentation but also to other applications) turns the pasted objects’ caption into Times Roman.

I own this findings to someone called David, who posted the following to microsoft.public.powerpoint on 1999/12/15:
” I’ve finally tracked down the problem with Arial turning to Times New Roman on our systems.

Hi Frank,
Outlook 2000 prints the full information contained in the subject and in the location field. Earlier versions of Outlook print just one line per appointment and cut off all information which does not fit in that line. For all I know, there is nothing you can do about that, except perhaps, trying a smaller font (go to File / Page Setup and modify the Monthly layout).
Doris

Well, I do not know for sure, that there is not a registry setting