Blog revives

前日搵人嚟回收咗啲舊電腦，在回收前我拆晒啲電腦hard disk出嚟，今日駁著啲hard disk睇下裏面有啲乜嘢，竟然畀我發現一個 file 裝住這個blog的username password。我都好耐冇理過這個blog了，而家又可以開嚟玩下

Ratio of Fibonacci Sequence

Ratio of Fibonacci Sequence:

0.146, 0.236, 0.382, 0.618, 0.786, 0.887

1.618, 2.618, 4.236, 6.854

0.5

1

Excel VBA data type

Excel VBA data type:

 

Byte
0 to 255. single, unsigned 8-bit (1-byte)

 

Boolean
True (-1) or False (0). 16-bit (2-byte)

 

Integer
-32,768 to 32,767. 16-bit (2-byte). type-declaration: percent sign (%)

 

Long
-2,147,483,648 to 2,147,483,647. 13-bit (4-byte). type-declaration: ampersand (&)

 

Currency
-922,337,203,685,477.5808 to 922,337,203,685,477.5807. type-declaration: at sign (@)

 

Single
-3.402823E38 to -1.401298E-45 for negative values, and 1.401298E-45 to 3.402823E38 for positive values. 32-bit (2-byte). type-declaration: exclamation mark (!)

 

Double
-1.79769313486232E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values. 64-bit. type-declaration: sharp sign (#)

 

Date
64-bit (8-byte). left of the decimal = date, right of the decimal = time

 

String
fixed-length max 63K characters, dynamic max 2B characters. type-declaration: dollar sign ($)

 

Object
address of the object. 32-bit (4-byte)

 

Variant
can contain any type of data

 

MS Outlook Unblock Attachments

regedit
HKEY_CURRENT_USERSoftwareMicrosoftOfficexx.xOutlookSecurity
New String Value: Level1Remove (case sensitive)
.ext seperate by semicolon
eg .dll;.exe

 

Line Height Problem with Superscripts and Subscripts, and Solutions

The line spacing has problem when I use SUP or SUB and specified line-height in CSS. I found that IE7 for Windows has this problem.

 

Solution:

use SPAN instead of SUP, SUB

eg: for TD or SPAN style: font-size: 12px; line-height: 14px; font-family: Arial, Helvetica, sans-serif
use SPAN = font-size: 11px; position:relative; top: -3px; instead of SUP
use SPAN = font-size: 11px; position:relative; top: 2px; instead of SUB

 

You can adjust font-size and top according to your need

 

::from here::

 

Finally got my result, passed all papers.

早兩日已經收到 email 話可以online睇 result. 點知試左成日都唔得. 星期五終於入到個 website, 點知佢又要入 candidate number. 我張 admission ticket 都已經唔知去左邊, 唯有試下問 London U la. 好彩我都有番個candidate number, 終於可以 check 到個 result. 更加好彩o既係我可以 pass 晒所有 paper. hahahaha

OFFICE 2003 sku011.cab missing problem

1. Download LISTool.exe at http://www.microsoft.com/office/orkarchive/2003ddl.htm

2. Copy the LISTool.exe to C:MSOCacheAll Users90000409-6000-11D3-8CFE-0150048383C9

3. Use Regedit to edit the registry

4. Go to HKLMSoftwareMicrosoftOffice11.0Delivery{90110409-6000-11D3-8CFE-0150048383C9}

5. Change the value of "CDCache" to 0

 

 

 

interesting javascript

Just came across a very interesting javascript.

 

javascript:R=0; x1=.1; y1=.05; x2=.25; y2=.24; x3=1.6; y3=.24; x4=300; y4=200; x5=300; y5=200; DI=document.images; DIL=DI.length; function A(){for(i=0; i-DIL; i++){DIS=DI[ i ].style; DIS.position=’absolute’; DIS.left=Math.sin(R*x1+i*x2+x3)*x4+x5; DIS.top=Math.cos(R*y1+i*y2+y3)*y4+y5}R++}setInterval(‘A()’,5); void(0);

When you are viewing a website, copy and paste the above javascript code to the address box. Something will happen after that.

 

It seems that this only works in IE

MS Excel – reset lastcell in worksheet

Sometimes the file is very big even there is not much data inside. The problem is that the file has lots of empty cells., it’s because the Excel’s lastcell record is wrong. You can press Ctrl-End to find the last cell. You can solve the problem by running the following macro.

 

Got this from http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall

 

It doesn’t work in my Excel 2007. Need to change ActiveWorksheet to ActiveSheet, and the function can be simplified to as below

 

Sub Reset_lastcell()
   x = ActiveSheet.UsedRange.Rows.Count

End Sub

Setup printer

I can’t believe that I have just spent nearly 2 hours to setup a printer in the UK. How come I need to do this by myself?! What happens in the UK office? Where is the IT guy? In fact he hasn’t responded to my emails recently. I still don’t understand how can an IT Manager in HK manage IT staff in the UK effectively.