Wednesday, July 05, 2006

Excel news and other links

This is just a list of a bunch of websites with interesting Excel related reading.

From Unofficial Micorosft Office Stuff
Access - Excel - HTML - XML XML makes data transferable between applications. Here is a tutorial with downloadable files.
Excel - 2003- VBA Help File

Here is a downloadable compiled Help file covering the vagaries of Excel VBA. You can use this file without having to, necessarily opening the application. Excel 2003 VBA Language Reference
Lists in 2003 - Tabled in 2007
Split Large Text Files Between Worksheets. The vba code to process text files with more than 65536 rows.

From J-Walk
Excel 2007 Command Guide - maybe the solution to my problem with locating commands.
Excel 2003 to Excel 2007 command reference guide.
Wondering where your favorite Excel 2003 commands are located in the new Excel 2007 interface? Or just want to explore the rich, new design with a little guidance?
You're in the right place. We've developed a visual, interactive reference guide to help you quickly learn where things are. Note - only works if you are running the Beta Office 2007 application.
Joel On Excel Interesting reading for Excel users. At Joel on Software: My First BillG Review.
Office 2007 Delayed Again Microsoft said it will now aim for a launch of Office 2007 to business customers by the end of 2006 rather than an earlier target of October. Microsoft also said it would delay the general availability of the Office upgrade to early 2007 from its previous January target.

From Andrew's Excel Tips
Rounded Comments and New Book Navigator Andrew has created some free Addins that are pretty useful. Try them out.