Migration to Excel 2007 - A nightmare for customized userforms

[AncientTiger]

A few years back, I had developed an EXTENSIVE, multi-part utility for my workplace using Excel and customized userforms. This app incorporates several OCX and DLL components native to Office and Windows 2000/XP.

Our techs have upgraded our office versions to 2007, and now my userforms are DEAD. We're getting licensing errors and missing activeX errors out the waahzoo.

Until today, I haven't even OPENED a 2007 workbook, so I'm a caveman looking at the instrument panel of a freakin' F16 right now. I can't even FIND the VBA editor!

I guess what I'm shooting for is a link to a FAQ that I've missed, or some sort of resource that could help folks in my position. The app in question is a mission critical tool that we use each and every day. We've been slapped back to chisels and stone tablets by this crap.

ANY help would be GREATLY appreciated


------------------------------------
Over 20 years of programming, and still learning every day!

 

[macropod]

Hi AncientTiger,

To access the vbe via the ribbon system, you need to activate the Developer tab - see under Excel Options|Popular. OF course, you could access it via Alt-F11, just as you always could, and macro via Alt-F8.

I think you're learning a valuable lesson your techs should have been aware of - before rolling out a new system or upgrade, test that everything you've got will work with it and redevelop as necessary before the rollout.

Cheers

[MS MVP - Word]

 

[AncientTiger]

Thanks Macropod! I'll give it a whirl next time I'm on duty.

Yeah, with our bunch, I'd learned that years ago unfortunately. Our tech team doesn't really concern themselves with anything anyone has out in the branch offices, they just come in, update/upgrade/patch, and leave.

So, I've got a saying, "2 hours of patching on their part, 2 weeks on my part of fixing their crap".

Sad.



------------------------------------
Over 20 years of programming, and still learning every day!

 

[DaveInIowa]

I feel your pain. We "upgraded" a couple months ago and I'm firmly in the Ribbon haters camp, mostly due to Microsoft's removal of custom toolbars. There's a few nice features in the new version but overall, not worth it. Did you get the interactive upgrade guide installed with your new version? If not, you can find it here:

http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[strongm]

>due to Microsoft's removal of custom toolbars.

I still fail to understand exactly why they thought doing so was a good idea. And they compound the error by not allowing VBA to access the ribbon.

 

[fumei]

...because Microsoft hates the idea of anyone actually knowing what to do with their products. IMO, 2007 was/is a conscious, deliberate, move to restrict their products (at least the Office apps) to people who do NOT know what they are doing.

Virtually all the "power-users" I know - people who really knew the Office apps - find that 2007 is worse.

I know I do. I can not stand it, and will not use or support it. Our organization (30,000 users) will be moving to 2007 (or later, by the time they actually do it...), and I was asked to head up the end-user training side of it, PLUS "conversion/verification" of the literally thousands of files of existing templates/macro code. I flatly refused. Someone else can take that nightmare. Fortunately, it will most likely be two years before it really happens, and I should be able to just squeak into retirement before that smacks this place in the face.

There must be hundreds and hundreds of templates that use FileSearch. Oooooops....every single one of them will crash and burn with 2007.

Gerry

 

[ajcarr]

Excel 2007 is a nightmare - Microsoft have made so many annoying little changes. I have several applications which use full screen mode (especially for non-technical users) and I used to use the status bar to keep the user informed during long processes. In Excel 2007, the Status bar is no longer visible in full screen mode. I thought I would compromise by minimising the ribbon but how? You can do it easily with Ctrl+F1 from the keyboard but I haven't yet found a way of doing it easily from VBA.