Hi Jan Karel
Thanks for jumping in and correcting my mistake.
As the OP was from some time ago, I didn't know whether you were
"around" to pick it up!!!

In addition to the help that Ron has put on his site, I came across this
add-in from MS recently, which inserts a Get Started tab on the ribbon
with lots of useful help for new users when trying to get to grips with
the new Ribbon layout
http://snipurl.com/1jr7e

This includes an interactive guide where you can see a 2003 layout,
hover over the command and it will show you where that is now located.
Click on the command and the screen changes to XL2007 with the area of
the Ribbon highlighted.
There are direct links from the new ribbon tab to MS sites with demo
videos etc.

--
Regards

Roger Govier


"Jan Karel Pieterse" wrote in message
...
Hi Roger,

There was a small typo in Jan Karel's formula to be entered in A1
=INDEX(FILES,ROW())
should have read
=INDEX(FILELIST,ROW())

In XL2007, to Insert the name Filelist, Formulas tabDefined Names
sectionDefine Name

Thanks for jumping in and correcting my mistake.
Ron De bruin has a nice page which shows you what commands went where
in XL2007:
http://www.rondebruin.nl/0307commands.htm

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com