Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 and over used installation key
Just had an interesting problem with a customer. He reported that a macro
wouldn't run. When I debugged, I found that a macro statement that counts the columns in the used range was returning an overflow error. And another statement that counted the rows in the used range also reported an overflow error. The used range was small, A1:V195. I suggested he upgrade his copy to insure he had the latest updates. He tried. However his installation key, which came from a friend, would not allow him to upgraded - the key was "over used". It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. I didn't see what message he got when he started Excel, so I don't know if he got any warnings. Obviously he didn't get any that made him think Excel and addins wouldn't work. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 and over used installation key
It appears that when an installation key is over used that Microsoft is
turning off some of the features in VBA. It is odd but that just doesn't seem very plausible to me. MS has never been reluctant to get in your face if it thinks your unlicensed, etc. I think (hope) it's something else but I can't think of what it might be. -- Jim "Bob Flanagan" wrote in message . .. Just had an interesting problem with a customer. He reported that a macro wouldn't run. When I debugged, I found that a macro statement that counts the columns in the used range was returning an overflow error. And another statement that counted the rows in the used range also reported an overflow error. The used range was small, A1:V195. I suggested he upgrade his copy to insure he had the latest updates. He tried. However his installation key, which came from a friend, would not allow him to upgraded - the key was "over used". It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. I didn't see what message he got when he started Excel, so I don't know if he got any warnings. Obviously he didn't get any that made him think Excel and addins wouldn't work. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 and over used installation key
Jim, I agree. I could not find any other cause however. I did find out that
the user did have the beta installed. However, I had the beta on my machine and no problem when I put a legal copy of 2007 on it (I since decided to reformat that machine when I put vista on it.) Bob "Jim Rech" wrote in message ... It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. It is odd but that just doesn't seem very plausible to me. MS has never been reluctant to get in your face if it thinks your unlicensed, etc. I think (hope) it's something else but I can't think of what it might be. -- Jim "Bob Flanagan" wrote in message . .. Just had an interesting problem with a customer. He reported that a macro wouldn't run. When I debugged, I found that a macro statement that counts the columns in the used range was returning an overflow error. And another statement that counted the rows in the used range also reported an overflow error. The used range was small, A1:V195. I suggested he upgrade his copy to insure he had the latest updates. He tried. However his installation key, which came from a friend, would not allow him to upgraded - the key was "over used". It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. I didn't see what message he got when he started Excel, so I don't know if he got any warnings. Obviously he didn't get any that made him think Excel and addins wouldn't work. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 and over used installation key
Bob
Did the user uninstall the beta before installing RTM? Bear in mind the beta is time limited with a *maximum* deadline of End of March -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Bob Flanagan" wrote in message ... Jim, I agree. I could not find any other cause however. I did find out that the user did have the beta installed. However, I had the beta on my machine and no problem when I put a legal copy of 2007 on it (I since decided to reformat that machine when I put vista on it.) Bob "Jim Rech" wrote in message ... It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. It is odd but that just doesn't seem very plausible to me. MS has never been reluctant to get in your face if it thinks your unlicensed, etc. I think (hope) it's something else but I can't think of what it might be. -- Jim "Bob Flanagan" wrote in message . .. Just had an interesting problem with a customer. He reported that a macro wouldn't run. When I debugged, I found that a macro statement that counts the columns in the used range was returning an overflow error. And another statement that counted the rows in the used range also reported an overflow error. The used range was small, A1:V195. I suggested he upgrade his copy to insure he had the latest updates. He tried. However his installation key, which came from a friend, would not allow him to upgraded - the key was "over used". It appears that when an installation key is over used that Microsoft is turning off some of the features in VBA. I didn't see what message he got when he started Excel, so I don't know if he got any warnings. Obviously he didn't get any that made him think Excel and addins wouldn't work. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Installation | Excel Discussion (Misc queries) | |||
An Error has Occurred during the Microsoft Excel 2007 installation | Setting up and Configuration of Excel | |||
Office 2007 Installation | Excel Worksheet Functions | |||
Installation of Office 2007 | Excel Discussion (Misc queries) | |||
Installation of Office 2007 | Excel Discussion (Misc queries) |