如果要判斷剪貼簿是否有資料可以使用 CountClipboardFormats API 函數
 

Declare Function CountClipboardFormats Lib "user32" () As Long

Function IsClipboardEmpty() As Boolean
If CountClipboardFormats = 0 Then
  IsClipboardEmpty = True
Else
  IsClipboardEmpty = False
End If
End Function

(閱讀全文)

 (Advance User Only)

 When you're offering an add-in through your website you usually have no connection to the people who are using your programming work. It is not unusual that you have discovered (or been pointed at) bugs in your code or that you've done some updating to the utility you'd like your users to benefit from. Sometimes it might be useful if your users could be notified automatically of such updates (many software titles have such a mechanism built-in). This little article shows a way to include that functionality with your add-in.

Details: http://www.jkp-ads.com/articles/updateanaddin.asp

If you find some DLL's in Excel cannot be removed by regsvr32 /u, try this freeware.

(閱讀全文)

EH 問題

排列組合1-49號碼, 任選6個不重複, Combin(49,6)=13983816 種排列方式

最小的總和是1 +2 +3 +4+ 5+ 6 = 21, 最大的總和是44+45+46+47+48+49＝279 都只有一種排列

請問如何計算另外其他合22-278 的排列數目, 例如合是101,共有58446種排列

(閱讀全文)

Sub CharCounts()
    
    Dim i As Long
    
    With ActiveCell
        Debug.Print .Characters.Text, .Characters.Count
        
        For i = 1 To .Characters.Count
            Debug.Print .Characters(i, 1).Caption, .Characters(i, 1).Count
        Next i
    End With
    
End Sub

(閱讀全文)

If you are a developer or just concerned with text processing tasks, the Regular Expression Laboratory is a tool that you need. In fact, you felt that you need a program like this but could not formalize your needs. We have done this job for you. Now you can construct your regular expressions with much ease and test them by applying to an arbitrary text.

Details and Download: http://www.silveragesoftware.com/rxl.html

另外由 Ming 提供的 The Python Regular Expression Debugger

Ref: Regular Expression

SHUTDOWN

Syntax        SHUTDOWN [logoff_option]  [/m ＼＼Computer] [options]  logoff_option:

/i         Display the GUI (must be the first option)
/l         Log off. This cannot be used with /m or /d option
/s         Shutdown
/r         Shutdown and Restart
/a         Abort a system shutdown. 
            (only during the time-out period)

/p         Turn off the local computer with no time-out or warning
               (only with /d)
/h         Hibernate the local computer (only with /f )
/e         Document the reason for an unexpected shutdown of a computer 

options:
/m ＼＼Computer  : A remote computer to shutdown.

/t:xxx         : Time until system shutdown in seconds. 
                  The valid range is xxx=0-600 seconds. [default=30]    

/c "Msg"       : An optional shutdown message [Max 127 chars]

/f             : Force running applications to close.

                 This will not prompt for File-Save in any open applications.

                 so will result in a loss of all unsaved data!!!

/d u:xx:yy     : List a USER reason code for the shutdown.

/d P:xx:yy     : List a PLANNED reason code for the shutdown. 

                   xx Specifies the major reason code (0-255)

                   yy Specifies the minor reason code (0-65536)

Options in bold are for Windows 2003 only

Details: http://webtools.live2support.com/windows/shutdown.php

這個計劃的目的是協助 XML 軟體工具發展者測試其軟體是否具有處理中文的能力提供使用者查詢各 XML 軟體中文處理能力的資訊。

http://xml.ascc.net

http://xml.ascc.net/zh/big5/index.html