October 2009
When Excel 2003 doesn't display data and Excel 2010 information
Wed, 28/10/2009 - 8:18am — jethroI 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.
Windows Live Mail
Wed, 21/10/2009 - 11:33pm — jethroThe 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.
News from around the Web
Tue, 20/10/2009 - 1:47pm — jethroWindows 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
Dreamcoat Photography - Family Portraits
Sat, 10/10/2009 - 10:15am — jethroJude and I have started a new business – Dreamcoat Photography. The website is not up yet, but we will be building it in the near future.
We are taking family portraits and will be soon open for business.
In the meantime here are some of the photos we have taken so far.
Riding and other bits and pieces
Sun, 04/10/2009 - 8:49am — jethroBack to work and back to an inbox full of things to do. I have spent a massive amount of time this last week working – the sailing holiday is now a dim and distant memory!
First some riding news. I got my bike back with the rear shock rebuilt (under warranty) and took it for a test ride with the MTB ride group yesterday. It held up just fine and the ride was an epic one - if a little long for my liking. The Saturday MTB group is back – meeting at the Wolves Bike Den every Saturday at midday for an epic ride like this. All ages and experiences welcome.
Map and terrain detail on bikely of the Ewen Maddock Dam Ride Click the pictures for more detail.
Site Construction and Maintenance by Jethro Consultants
Gidday
Glad to have you stop in.
I write about my family, the internet, technology and gadgets, productivity with Microsoft Office applications Excel Tips and more.
Instagram Feed
Find Us On...
Subscribe by RSS
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Timothy Miller © unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission. Privacy Policy
Recent comments
10 years 37 weeks ago
10 years 37 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago
10 years 39 weeks ago