Monthly Archives: November 2010

65

Sergio Valente put it best when he said, ‘How you look tells the world how you feel.’ If you can slip two fingers between your neck and the buttoned collar of a new dress shirt, the shirt will fit comfortably … Continue reading

Posted in Uncategorized | Leave a comment

Do… For…

I’m always in need of the a for…in…do batch command but always found the decription provided overly complext, Powershell does it really well but again is complex (for me at least). I found this article and it mader a lot … Continue reading

Posted in Uncategorized | Leave a comment

Looping through a series of Chart data points

This has taken an age to find but turned out to be very simple, simply put I have a ton of bar charts and want to add series name to them. to do this manually is a pain in the … Continue reading

Posted in Uncategorized | Leave a comment

Schedule charts in Excel

Every now and then I need to get a spreadsheet opened data refreshed and then published onto a sharepoint site. Once you have the data set-up in the spreadsheet. Add the below code either to Private Sub Workbook_Open() or in … Continue reading

Posted in Uncategorized | Leave a comment

Elevator Pitch

The elevator door opens. And there stands your ideal investor. It’s the chance of a lifetime. But that chance only lasts as long as the elevator ride – you have less than a minute to make an impression. Hopefully, you’ve … Continue reading

Posted in Uncategorized | Leave a comment

Sticky Notes

Using Win7 Sticky Notes is great, however I want to be prompted with a confirmation to delete when I want to actually delete. Unfortunately I checked the box to not prompt and hit [OK] To revert to default behaviour I … Continue reading

Posted in Uncategorized | Leave a comment