Tuesday, May 18, 2010

What's new in OneNote 2010

I don't use OneNote enough - I've had too many other knowledge libraries. But I reckon the 2010 is the one where I take more notice. I already have some notes in the 2007 edition, the 2010 edition seems to be a landmark.

in reference to: Facebook (view on Google Sidewiki)

Tuesday, May 11, 2010

Saturday, May 8, 2010

The Pesky Excel 2010 Object Model difference

This afternoon, I was working with Access 2010 on an Access datafile that was created and is in production in an Access 2007 / Excel 2007 environment. There is inter application Automation - VBA in Access has a reference to Excel. Things seemed to be working smoothly until I noticed some odd glitches. On one Access 2010 machine, certain parts of code would not work - the error message was something like "unknown database object". On another Access 2010 machine, the DATE() function gave an error. Checked the object library references in the VBA IDE. Found that Excel 14 / Excel 12 alternately were missing in action. In the relevant Office version, the Excel Object Model Library was there, but not automatically ticked, while the wrong, missing Excel Object Model Library was.

After a while, I avoided using Access 2010 to develop the project.

Reblog this post [with Zemanta]

Thursday, May 6, 2010

Bye Clipomatic, Hello ClipX

I used to be a fan of Mike Lin's Clipomatic. Then my Windows XP became too crowded and my mult-clipboard programs stopped working properly. Now I am on Windows 7 but Clipomatic is sadly out of date and does not cope with the security settings to %Program Files%

Fortunately, ClipX has been updated, trying out the beta 7 x86 release.....

in reference to: ClipX (view on Google Sidewiki)

Tuesday, May 4, 2010

Saturday, May 1, 2010

Life after VBA

It's difficult to figure out what lies after VBA when you are cool with VBA in Office and see that there are nice things you could do but they are in .NET. Aside from the skilling up and hoping that the .NET bits and pieces are installed on end users' machines, it's the case of what features that could be tempting. .NET is evolving at a rapid rate but not every feature is grokkable or even worth grokking to you.

Here are some videos.

in reference to: How Do I Videos for Office (view on Google Sidewiki)