A bit more from the past, in this example file you can play a video natively within a VBA form – cool!
The example file here: Video API
Tag: Videos
Excel 2007 Tables – the basics
Today I took my first look at Excel 2007 tables. I’ve hardly use Excel 2007, for obvious reasons, so I’ve not really played with many of the “new” features.
I did a bit of research and basically there are already a few good spots out there for table related stuff:
An incredibly cheesy Microsoft video, it does show all the main features (doesn’t that table look professional!)
Jan Karel Pieterses’ introduction and VBA methods
And Ron de Druin VBA page here
This chart shows my feeling towards tables in Excel 2007 over the last 3 hours:
In summary, I think tables have been done really well, there are easy to use and makes sense. I think that the new reference system (table name[column]) is good, but just like named ranges, can cause as many issues as it might solved, especially when used by relatively low skilled Excel users. Most of the stuff that I can see in tables was already there, and has “just” been made much easier to get at, I like the auto-update-y nature of tables, but that always worries me a bit too.
Just for completeness I have done a quick video to add to the tables database!
Excel VSTO Addin example video!
A day and a half behind schedule, here’s a long (10mins!) video of how to write and “deploy” as VSTO addin for Excel 2007. It was, to be honest, a nightmare to do, as my PC is about 100 years old! I promise that as soon as the funds allow I will get a new one – at least now I have a legitimate reason for the spend!
The sound and the image get out of sync about half way through, for which I apologise, but I’ve already spent enough time on it, and people should be able to keep up, there’s nothing to difficult about it. Editing in Widows Movie Maker is rubbish!
Anyway, here it is!
MIE Sample VSTO Timer Addin.zip project to go with it, should anyone be interested
I’m glad that’s done!!!
Note to self, don’t do end to end videos!
Microsoft, you just get office developers don’t you?
hummm, insulting, fun, totally missing the point, a bit of all three?
VBA Person
2 VSTO VIDEOS, OK, A1, BTW, GR8 ….
Ok, ok here are some videos about VSTO (…emmmm, 2005 SE…)
First is from Andrew Whitechapel and is an example of how easy it is to do something very basic?!. Then it shows some nice solutions. At 6 mins long it does very little to help anyone understand anything, and it’s in c# of course.
The next little snip bit is form a MS site “The Visual Side”. Happily it only works with IE (ha!). Now again this is quite pants, but the interesting thing is at the end, listen if you can bare it, to the bit where Eric Carter talks about the new a more exciting version of VSTO (Orca ? Arcas)… god charm down, 2005 SE only just shipped
Visual Studio 2005 Tools for Office for the 2007
Now I’m not criticizing either of these two chaps both of whom have written good books and host blogs with good content, but maybe MS should focus their efforts on making more meaningful and worthwhile content… writing help files that are helpful, oh and i don’t know getting MSDN content that is decent…
Now this is a useful link