Replies

Because you use “appWD” and Rory has used “AppWord”, a mispelling on Rory’s part i think.
Ewan.

Hello all,
I have heard of washing the keyboard and even circuitboards and I agree with Merc with what he said. However, perhaps you should take care with the water, what alot of us get out of the tap is not exactly pure H2O. If you live in a hard water area (your kettle gets furred up alot) a limescale deposit may be left behind as the water evapourates. I wouldn’t normally think this is a problem as to my knowledge it is not a conductor or semiconductor and many circuit boards have a protective varnish coating. The sticky bit (excuse the pun) will be plugging all the stuff back in as there is a chance that one or more contacts will be insulated by this deposit. It’s up to you whether you want to go to the effort but as has been said you haven’t much to lose, and doing nothing just leaves you with a toffee coated m/board. Should smell nice as the CPU heats heats up, but watch out for the wasps and ants!!

Best of luck,
Ewan

Well the easiest way to check the connector is to get hold of/borrow another keyboard off a known good system. If the symtoms persist then its obviously the connector in the case is suspect.
Ewan

The answer might be because of the use of a built in dialog box. As far as Excel is concerned this is not using VBA. Try assigning the selected file path and name to a variable then using the Workbooks.Open method. Ofcourse you shouldn’t execute the Open file dialog box.
Ewan

I can find the built in dialog box list of arguments easily enough, it’s just that some of the argument names don’t relate very well to there function.
Ewan

I’m running 95b and yes it does auto adjust.
Ewan

Is it anything silly like the keyboard has had keys remapped? Right country settings?

I have to wear anti-static coats at work. The labeling says something like 2percent conductive nylon. Check for similar labeling on your bag. If it’s just 100 percent man made fibres then there is a good chance that large charge can build up. As has been already stated, it’s questionable whether this would enough to fry the electronics unless the port connections were exposed.
I would have thought just damaging memory (or even ports) wouldn’t leave a dead laptop, at least some POST screen/sound indication would be given about corrupt/missing memory.
Ewan

Do you smoke? Is the PC well ventilated? Pets? Children? I know someone whose kids seem to think that the tray loader is great for bread and things (toaster?!!!?), oh and they get all kinds of crap on the CDs, like the stuff you should put on toast…
Othr things to consider are faulty power supply or power cable to the the drive.
Ewan

As windows remembers the last partially sized setting you could try and run this code:
Sub resizingwindow()
‘
‘ resizingwindow Macro

With Application
.WindowState = xlNormal
.Top = 1
.Left = 1
.Height = 300
.Width = 300
End With
Application.WindowState = xlMinimized
Application.WindowState = xlMaximized
End Sub

I will attatch a blank worksheet with this macro in it if you don’t feel like copying it to VBA.
On my system (win95b, excel97sr2), after running the macro then pressing the restore button takes me back to the 300×300 setting.

Ewan

I’m certainly no expert, but can you get hold of a CDROM drive from a system that doesn’t exhibit this behaviour?
Ewan

Especially true in VBA where “&” is also used to concatate strings and other symbols have their own meaning.
Ewan

Does it happen for all workbooks? Have you checked for VBA routines in any open workbooks for the Workbook_WindowResize event? Could be corrupt code or simply a routine with badly written logic.
Ewan.

No problem, just had me worried i had posted a load of duff advice, making a of myself!! I admit I didn’t see the bit about 10 days .
BTW I realised the I was looking at the conditional formatting from the wrong direction. Instead of conditionally applying formatting for w/ends and holidays it should be the other way around…
Format all cells as if they were weekends and holidays, i.e. thick borders. Then set the conditional formatting to apply the thin borders (or whatever) to normal weekdays. In my previous attatchment the conditional formula would be :

=AND(NOT(MATCH(B$9,PublicHolidays)),OR(WEEKDAY(B$9)>1,WEEKDAY(B$9)<7))

So the formula says "if it isn't a holiday AND it's monday to friday apply the format"
Ewan

The following routine will display the Insert date/time dialog box. The InsertAsField (the Update checkbox) at the bottom is then set to false, regardless of the user selection. Finally the settings are caried out, including cancel, if that was clicked.

Sub myinsert()
With Dialogs(wdDialogInsertDateTime)
.Display
.InsertAsField = False
.Execute
End With

End Sub

You can set properties proir to displaying a dialog box using the same method as above. If you use .Show instead of .Display the box will execute on clicking OK. Have a look at built in argument list in VBA help and displaying dialog boxes.

Ewan