Spy Journal 3.0 Filtering the web for you

So I was all excited. Office DevCon 2009 was in Brisbane this year. We develop in Excel and VBA. I was looking forward to networking with others who do the same, and learning some new techniques and tricks.  The session track précis hinted at new reporting techniques, building reports for excel-centric clients, new VBA forms and more. I skipped the first day because there was only 1 session I wanted to go to. I was all excited about the second day because I thought (wrongly) my desires would be met. But no. I should have read the presenter profiles page first!.

These guys were all Access gurus. And they seemed to know what they were doing, but when it came to Excel they ignored the massive functionality of Excel, and treated it primarily as a report display system.

I think I am going to offer to present next year.

I came across an interesting issue yesterday. I found a limit that I was previously unaware of in Excel 2003.

I had written some code that was taking data from a large data set into an array, filtering for some specific information and writing the results to another array. Then I was attempting to paste that array data into a range in the spreadsheet as a report. All was working well until I selected one specific set of inputs and ran the report. Suddenly it stopped pasting halfway though the paste. That is it would paste some of the data and not the rest and the code would break on the paste function. After some analysis I determined that the particular cell it kept breaking on had 1400 characters in it. Some research on Google helped. I discovered two things.

The following is the sample email that pops up in Windows Mail. Windows mail is being gradually replaced by Windows Live mail. This is a much better free email application than the old Outlook Express which technically wasn't free, you had to buy windows XP to get it. Windows live mail can be downloaded for free as part of the live suite.

I use it for a lot of clients as an easy way to manage their Hotmail or Gmail accounts on their PC.

Windows Mail is the successor to Outlook Express

Windows Mail builds on the foundation of Outlook Express, adding a variety of new features designed to make your e-mail experience more productive and fun, while helping to reduce risks and annoyances such as phishing and junk e-mail.

Windows Phone Website – if you use a windows mobile then there are plenty of resources here. If you don’t you probably should!

Insert the date and time in your OneNote notes. Shortcuts are:

• To insert the current date and time, press ALT+SHIFT+F.
• To insert only the date, press ALT+SHIFT+D.
• To insert only the time, press ALT+SHIFT+T.

Explanation of trusted documents feature in Office 2010

Outlook 2010 has some cool calendar features

Windows Media Centre Hints and tips from Missing remote