Replies

I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,”>0″)+countif(value(range,”<2")))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,”>0″)+countif(value(range,”<2")))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

I’ve been looking for a solution to “This Intel Management Engine Interface” problem for a good month now. I’ve searched MS, forums, and Intel. It appears they have not updated the drivers to Win7 as of yet. They do plan on doings so in the future. Some forums suggest to run it in legacy mode? Not familure with how thats done in Win7. I would like this solved also since this is the only hangup to my upgrading.

Just a note on my experience with the MEI:
The Upgrade Advisor said my MEI was not compatible with Win7. I searched everywhere and the answers as to just what exactly the MEI is (in laymen speak) were amazingly diverse. I read that the MEI affected (pick your choice) Enterprise communications, or the sound would not work without it, or was a heat sensing monitor, or, or… I decided to wing it and install Win7. After the install the only exclamation point in Device Manager was the PCI Simple Communications Controller. I don’t exactly know what that is either. I tried to “Update Driver” in Device Manager but it said it couldn’t find anything. Next I “Browsed” for the driver and pointed it to “Windows.old” ( I was doing a clean-install). A dialog box opened saying the driver had been successfully installed and then it listed the name of the driver on the next line – and it was Intel Management Engine Interface! The exclamation point was gone in Device Manager. Go figure. I still don’t know exactly what the MEI is but evidently Win7 is happy – so I am too.

I know this doesn’t answer your original question but I thought I would share just in case it helped. Good Luck.

Well, after I had tried every trick I knew to get it going, I took it to Best Buy since it was still under warranty. Turns out it was the HD. They replaced it and it should be ready to pick up tomorrow. Thanks for your help.

What was your previous operating system, and did you do a backup or a disk image before you did the clean install? And what version did you install – 32-bit or 64-bit, and Premium, Ultimate or???

The last was Vista Home Premium 32-bit and I installed 7 Home Premium 32-bit. I backed up all my data but did not do a disk image (I have to learn how to do that).

That article says:
“Speaking of hardware and visiting manufacturers’ Web sites, now would be a good time to update your firmware, especially if you’re not in the habit of doing this on a regular basis. Go to your system manufacturer’s site for system firmware updates. See “Firmware and You: A Comprehensive Guide to Updating Your Hardware” for details.”

They are referring to the BIOS of the PC on which you intend to install Windows 7. Sometimes there have been BIOS=firmware updates since you bought the PC, and sometimes it is worth updating it. Some manufacturers (e.g. Dell) make this process very straightforward. In “the old days” you took your life into your hands doing BIOS updates; now it’s less hairy.

There is a BIOS update available. When you update the BIOS does it update anything that sits in System Devices in Device Manager? The reason I ask is the item that the Upgrade Advisor says is not compatible with Win7 (Intel Management Engine Interface) is an item in Device Manager under System Devices. Can I just double-click it in Device Manager and ask it to update driver? Or should I try the BIOS update.

A clean install will wipe the drive clean and start over.

If you do a upgrade, then one needs to run the Windows 7 adviser and remove all that is NOT compatible with Windows 7. Also it pays NOT to have to many external devices attached as the install will spend time looking for drivers. I just keep my network and printer connected.

I have yet to do any “Firmware” update for any new OS. Where did you read the information?

It was a PC World article How to upgrade to Windows 7. And I was hoping it was a personal preference kind of thing. Also, the bit about uninstalling stuff – can’t find where I read that but I sort of figured the article was referring to those folks who were upgrading rather than clean installing.

I have another issue I am researching right now where the Upgrade Advisor is saying the Intel Management Engine Interface is not compatible with Win7. Gateway’s Live Chat support could only tell me “The Intel Management Engine Interface enables communication between the host OS and the Management Engine firmware. MEI is bi-directional, and either the host or Intel AMT firmware can initiate transactions.” When I asked what that all meant he said I would have to contact Intel. I’m going to check the Intel site now. Can anyone tell me if this is important? Meaning will it prevent me from installing Win7?

There are two situations in which Word does not display the macro warning:

1. In the Trusted Publishers tab of Tools | Macro | Security…, you can tick the check box “Trust all installed add-ins and templates”. If so, templates and add-ins in your user templates and Word startup folder won’t display the macro warning.

2. If the document or template has been signed with a digital certificate, and if you have indicated once that you trust this certificate, the macro warning will not be displayed. You can see which certificates you trust in the dialog mentioned under 1.

I think the first item is the reason why. I do have the “Trust etc.” box checked although I didn’t check it. Must be a default and I hadn’t noticed the way different files opened. I just wanted to be sure that the file wasn’t corrupted.

Thanks Hans.

Oh yes, many things. I believe Application.GoBack repositions the insertion point. I don’t know whether you would want to run that before or after your code to display/hide the Document Map. I guess try it both ways and see which works best.

Edit: Your code block appears to be missing End If at the end, but that might just be a glitch in pasting it here in the Lounge. The compiler will let you know.

I did miss the End IF, thanks. I put the code before Application.GoBack since I figured it should check the file name first. And it works like a charm. It probably seems silly to bother with this, but I get tired of constantly turning Document Map off since I only use it in one document.

Thanks all for the help.

You can create a macro in your general macro container (Normal.dot) that runs automatically every time a document opens. This happens if you name the macro AutoOpen(). You can check either the name or the complete path+name of the file, as needed. Check out the ActiveDocument object for specifics.

I already have an AutoOpen() so can AutoOpen() do more than one thing? Below is the current AutoOpen() followed by an attempt to write the code to check for the file name and open/close the Document Map.
Sub AutoOpen()
Application.GoBack
End Sub
This is my code for Document Map. It only checks for one file name – I figured I’d start small since I haven’t really done much with Word macros. I will have to include another If, Then, Else for the 2nd scenario since one file uses the Document Map and the other doesn’t. If I am anywhere near using the correct code would I add it after the Application.GoBack line?

If ActiveDocument.Name = “DocA” Then
ActiveDocument.ActiveWindow.DocumentMap = True
Else
ActiveDocument.ActiveWindow.DocumentMap = False [indent] [/indent] Thanks.

Yes, the macro security is to disable with notification if it comes from an untrusted location. Interestingly enough, I noticed today that it now seems to be working – sporadically. Sometimes it goes back and sometimes not. I will watch it closely and see if I can figure out a pattern.

Well, I did try MVP Graham Mayor’s macros but still no change. This is probably all the time I want to spend on this as I am only evaluating a free trial that came with my PC. I figured why not try it – and I am pretty sure I won’t bother spending the money on Office 2007. First, I own 2003 already so no out of pocket expense. But more important the learning curve is a bit much. I can’t imagine a business switching to 2007 – productivity would go down the tubes. I’ll play with it a bit more before I uninstall to see if I change my mind. Thanks for your help Hans.

Looking in VB, the macro is in Normal, Modules, NewMacros. I tried the code in the link but there was no change. And the line (Application.GoBack) isn’t commented in the actual macro. That was my error when posting here. This same macro works fine when I use Word 2003. I’ll keep researching.

Thanks Hans.

Doc,
I found the following that explains why I couldn’t get printer sharing to work – well, it explains that it is a known issue. So at least now I feel vindicated.

Doc, I finally “solved” the printer problem. After spending a couple of days on the problem, I used all of my technical skills, and bought a wireless printer!!! Now all my PCs can see/use it. Thanks for your help.