I have a curious problem. A VBA based XL application that is heavy on
the use of graphical objects has recently stopped working in XL2007
after some hotfix updates were applied (at a remote site). It had
previously been fine.

I want to get XL2007 to show me its build version and a list of all
patches/hotfixes applied and dates to try and bracket the hotfix which
has caused the problem.

On previous XLs some basic version info would be easily accessible
under &Help &About (which is simple enough to ask users to do in fault
finding) but I cannot find it anywhere on these new fangled ribbon
things.

Is it still possible to get XL in its 2007 incarnation to tell you its
build configuration?
(preferably in a way that a simple minded user can follow)

Thanks,
Martin Brown

I've found that some code related to legend placement that worked in 2003 for
charts no longer works in 2007. I wonder how many other "improvements" I'll
have to deal with. You may want to post this in the Charting group as well.
--
HTH,
Barb Reinhardt



"Martin Brown" wrote:

I have a curious problem. A VBA based XL application that is heavy on
the use of graphical objects has recently stopped working in XL2007
after some hotfix updates were applied (at a remote site). It had
previously been fine.

I want to get XL2007 to show me its build version and a list of all
patches/hotfixes applied and dates to try and bracket the hotfix which
has caused the problem.

On previous XLs some basic version info would be easily accessible
under &Help &About (which is simple enough to ask users to do in fault
finding) but I cannot find it anywhere on these new fangled ribbon
things.

Is it still possible to get XL in its 2007 incarnation to tell you its
build configuration?
(preferably in a way that a simple minded user can follow)

Thanks,
Martin Brown

Office Button--Excel Options--Resources--About

Charles

"Martin Brown" wrote in message
...
I have a curious problem. A VBA based XL application that is heavy on
the use of graphical objects has recently stopped working in XL2007
after some hotfix updates were applied (at a remote site). It had
previously been fine.

I want to get XL2007 to show me its build version and a list of all
patches/hotfixes applied and dates to try and bracket the hotfix which
has caused the problem.

On previous XLs some basic version info would be easily accessible
under &Help &About (which is simple enough to ask users to do in fault
finding) but I cannot find it anywhere on these new fangled ribbon
things.

Is it still possible to get XL in its 2007 incarnation to tell you its
build configuration?
(preferably in a way that a simple minded user can follow)

Thanks,
Martin Brown

The equivalent dialog box for Help/About from older versions of Excel can be
found in XL2007 by clicking the Office Button, then click Excel Options,
then select Resources from the left hand listing and the last item in the
right hand panel should be "about Microsoft Office Excel 2007"... click its
"About" button.

Rick


"Martin Brown" wrote in message
...
I have a curious problem. A VBA based XL application that is heavy on
the use of graphical objects has recently stopped working in XL2007
after some hotfix updates were applied (at a remote site). It had
previously been fine.

I want to get XL2007 to show me its build version and a list of all
patches/hotfixes applied and dates to try and bracket the hotfix which
has caused the problem.

On previous XLs some basic version info would be easily accessible
under &Help &About (which is simple enough to ask users to do in fault
finding) but I cannot find it anywhere on these new fangled ribbon
things.

Is it still possible to get XL in its 2007 incarnation to tell you its
build configuration?
(preferably in a way that a simple minded user can follow)

Thanks,
Martin Brown

On Aug 21, 3:42*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
The equivalent dialog box for Help/About from older versions of Excel can be
found in XL2007 by clicking the Office Button, then click Excel Options,
then select Resources from the left hand listing and the last item in the
right hand panel should be "about Microsoft Office Excel 2007"... click its
"About" button.

Thanks for that.
I would perhaps eventually have found it by trial and error.

The "Check for Updates" button on that page works really well!
Mine appears to hang the system with the stupid wait icon if your
internet connection breaks whilst it is trying to phone home :(

And I mean broken at a level where although you can swap between
existing running tasks Vista does not respond at all to ctrl-alt-del,
and you cannot start any new ones. This might be a specific wierd
fault with my portable, but it looks to me like an XL2007/Vista
incompatibility. It has after about 20 minutes come up with an error
msg "Logon process has failed to create the security options dialog"
BIG RED X "Failure - security options". One button "OK" pressing it
returns me to the XL2007 waiting icon and it now displays (not
respoonding) in the top of the window. Dead in the water - again!!!! :
(

Unfortunately my portable does not have a reset switch. I never felt
that I needed one until the Vista / XL2007 combo came along :(

Regards,
Martin Brown