Saturday, July 24, 2010

The different types of Webpage Layouts

We were discussing the difference between static and elastic width webpage layouts in a class. Here's an interesting article

in reference to: A Guide on Layout Types in Web Design (view on Google Sidewiki)

Friday, July 23, 2010

Number and Date formats

I had trouble the other day trying to find the Office Help reference for the Date formatting placeholders in Word. The good thing about the Office suite is that Word, Excel, Access all share the same formatting syntax.

in reference to: Number Formats in Microsoft Excel (view on Google Sidewiki)

Excel Pivot Table Tutorials

by Debra Dalgleish - heaps and heaps of tips

in reference to: Excel Pivot Table -- Dynamic Data Source (view on Google Sidewiki)

Chandoo does conditional formatting in Excel like a rockstar

Some inventive ways to use Excel conditional formatting and this does not even need the latest Excel version.

in reference to: Conditional Formatting in Excel | Chandoo.org - Learn Microsoft Excel Online (view on Google Sidewiki)

Saturday, July 17, 2010

Wednesday, July 14, 2010

Revised Web References

Here’s a revised reading list for those who want a leg up to the world of web pages.

Friday, July 9, 2010

You've got .chm compiled Help files but you can't see the content


Actually, very frustrated - followed the instructions, copied the text to the .reg file but it didn't work. Fiddled for ages, then read more MSKB articles. The article shows a UNC path to your .chm files but really the files were on my local hard drive so UNC is not appropriate. After all that reading and testing, here is text for Windows 7 .reg file - copy this into notepad, save as a .reg file and run it - I ran it from an admin account and suspected UAC and elevated security issues with Windows 7 but that was a red herring.

Note:

  1. c:\refs is where I put the .chm files
  2. I used both the C:\ and the file protocol - I think the file protocol was the one that solved it.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions]
"UrlAllowList"="E:\\refs;file:///E|/refs"
"EnableFrameNavigationInSafeMode"=dword:00000001
"MaxAllowedZone"=dword:00000003

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions]
"UrlAllowList"="E:\\refs;file:///E|/refs"
"EnableFrameNavigationInSafeMode"=dword:00000001
"MaxAllowedZone"=dword:00000003


Microsoft Office 2007 Object Model Maps

For VBA programming. MSDN Office Developer Center Reference

in reference to: Object Model Maps (view on Google Sidewiki)