Replies

Q138619 in the MS Knowledge Base may help you.

But when I enter today’s date in cell A1 and tommorow’s date in B1. I get the following results:
Networkdays(A1,B1) = 2;
Networkdays(today(),B1) = 2;

Triva answer: Same as why there is Weeknum & WEEKNUM,
Workday & WORKDAY and Yearfrac & YEARFRAC.

Probably only Bill knows.

Bob_D

The attached workbook contains some examples using your data. Activate any data cell & then activate the advanced filter to see the options in sheets 1, 2 & 3.
On sheet 4, Cell A15 can be changed to any value within the matrix.

The explanation of what you want is really not to clear to me. Could you simply show what the results you would like to be. I work best by example. The advanced filter may not do what you want.

Bob_D

Please specify Excel Version & SR.

The advanced filter handles at least 10 columns.
But not knowing the criteria you setup it is difficult to make any comment. A simple example that fails to meet your expectations would help.
A common error in using the advanced filter is establishing the criteria properly. Are you using ‘AND’ or ‘OR’ column matches? . . .

Bob_D

This may also help.

This appears to be an incompatibility with Word 2000. One day I will install Word 2K if I can ever clean up the C-drive.

You appear to be viewing the doc in Normal View. Switch to Page Layout and then turn on view text boundaries ( Tools/Options/view tab & check Text Boundaries box).
You will see, in the sample supplied, 2 text areas outlined. There probably was a graphic inserted within the paragraph. Or perhaps a custom style! Are there any graphics in the original document?

This is confirmed by doing this:
Tools/Options/Print tab and uncheck Drawing Objects. The sample doc should print the way you woud ike to see it, but in Page Layout view it still will have the blank space between the lines.
Remember to restore the Drawing Objects check box or other documents may not print properly.

If you need to normally work on the doc & don’t want the extra space, it must be rebuil as Andrew explained.

Bob_D

Were the origina workbooks on a diskette. If so – sorry, look for backup.

With sheet to be inserted active, do: ctrl+a, ctrl+c
This will copy the entire sheet into the clipboard.

Go to sheet that need to be replaced. Do: crtl+a, ctrl+v
The contents of the sheet are replaced but the tab name remains.

I think this is what you need.

Bob_D

It is also safer to not process a file on a floppy.
If the floppy is removed at the wrong time the doc can become corrupt. I haved always told people that if they must use a floppy, close Word before removing the diskette.

Phil,

Only the Case statement needs lower case as shown by the note in Q159896.
“Note: Each Case statement below should be in all lower case. ”
Case “text1”
As I dislike typing I use copy/paste extensively.
The lines below produce the same results in the macro I posted above.
sTabTo = “text2”
sTabTo = “Text2”

No changes to default bookmark names were done. They are still Text1, . . .

Case “Text1” – give the error while
Case “text1” – executes properly. That’s all I know.

Bob_D

There is an extensive article about this issue on the Microsoft Knowledge base: Q162349

http://support.microsoft.com/support/kb/ar…s/Q162/3/49.asp

Basically: Get to sr-1 & better sr-2
But that won’t alter existing docs.
The objects are still there. Select the object, do copy & paste into an image editor. Delete the object in word and recopy/paste from the image editor.
But do this on 97/sr-1 ot 2 else the Big Red X can return.

Bob_D

Rory is correct. Does the attached meet your requirements?

Bob_D

Also check under Tools/Options/Print
the Draft Output box. This should be unchecked.

Draft mode does not print objects but they show in print preview.

Please reread Q159896 and you will see:

Note: Each Case statement below should be in all lower case.

Replace yours with something like the below:

Sub TabOrder()
‘
‘ TabOrder Macro
‘ Macro created 02/22/01
‘
Dim sTabTo As String
Dim dlgForm As Dialog
Set dlgForm = Dialogs(wdDialogFormFieldOptions)
Select Case LCase(dlgForm.Name)
Case “text1”
sTabTo = “text2”
Case “text2”
sTabTo = “text3”
Case “text3”
sTabTo = “text4”
Case “text4”
sTabTo = “text1”
Case Else
End Select
ActiveDocument.Bookmarks(sTabTo).Select
End Sub

This works for me w/Word97.

*** Geoff W. URL markup added ***

Look at Q159898

http://support.microsoft.com/support/kb/ar…s/Q159/8/96.ASP

Works with 97 & 2000.

As this activity occurs in WordPad, Word itself is not the cause.
I personally would check the autoexec.bat for a strange application being loaded.
I ran across something like this a few years back. It involved a keyboad watch application that monitored words being typed, replacing four letter words and the like with XXXX’s. The dictionary used was updated to include the user’s name. Try typing a four letter word in notepad. If XXXX shows up – you got it.
Definitly check the windows startup folder and autoexec.bat.