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
Videos
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!
Working with Colours in Excel – M.I.E Colour Manager
Here is the BETA version of my Colour Manager, and tool for creating colour pallets in Excel:
It’s a VB6 com addin, the only thing you really need to know is that you load a picture on the left and then click that picture to get the colour at that point. You can then click a pallet square to place it where that square is. Click the send to workbook button to send it to the active workbook.
However I have also made a video to show how to use it. Bosh!
Here is the file!
UPDATED FILE HERE:
MIE Colour Manager Beta 0.3.0.zip
Enjoy, feedback more than welcome.
Computer Chronicles
Here at MIE, we strive to bring you cutting edge news and information :
spreadsheet wars
Worth a watch if you have a 1/2 hour with nothing better to do!
Hair cuts have come along way!
Glass Orbs in Excel?
The other day a mate asked me to draw him some glass balls, I used Inkscape. Later, because I’m like that, I wondered if I could do it in Excel – this is the result – I don’t think Paint Shop has much to worry about!