香港新浪網 MySinaBlog
Emily | 31st Dec 2005, 23:59 PM | 雜談 | (603 Reads)

Happy New Year 2006


Emily | 30th Dec 2005, 11:36 AM | General | (864 Reads)

Windows ClipBoard and Office ClipBoard

An article describes two clipboards by TonyJollans.

View Article

 


Emily | 28th Dec 2005, 23:45 PM | UserForm / Object | (1720 Reads)

Import UserForm 立刻顯示方法

Application.VBE.ActiveVBProject.VBComponents.Import (ThisWorkbook.Path & "Userform1.frm")
UserForm1.Show
 
這是無法顯示的
 
 (閱讀全文)

Emily | 26th Dec 2005, 19:00 PM | WB & WS, API / Add-in | (1137 Reads)

IE收藏夹中的信息

以下是 API 方法列出及建立 url

 (閱讀全文)

Emily | 26th Dec 2005, 18:36 PM | WB & WS | (1256 Reads)

IE收藏夹中的信息

http://office.9zp.com/dispbbs.asp?boardID=3&ID=5636&page=1 曾有過討論

以下是另外一種方法列出及建立 url

 (閱讀全文)

Emily | 26th Dec 2005, 00:03 AM | WB & WS | (1372 Reads)

如何讓單元格裏的一段文字以逗號爲間隔顯示不同顔色

"深謀遠慮,深藏不露,詭計多端,有魄力,有野心,意志極強,洞察力極強,實數12星星之冠"

這是 EH 的一條問題

供參考,尋更好方法。

 (閱讀全文)

Emily | 25th Dec 2005, 12:37 PM | General | (1508 Reads)

RND (-1)

RND (-1)? 沒有看錯。

Added on 20 Mar 2006

SYMPTOMS

In Microsoft Excel, when you use the Randomize statement in a Visual Basic procedure to initialize the random-number generator, the Rnd function returns a different series of random numbers each time you use it in the procedure, even if you use the Randomize statement with the same number value before each Rnd function.

CAUSE

The Visual Basic documentation for the Randomize statement states that the Randomize statement uses the number argument to initialize a random-number generator, giving it a new seed value.

This information implies that the Randomize statement re-initializes the Rnd function, so that when you use the Randomize statement with the same number value preceding each Rnd function in a procedure, each Rnd function returns the same pattern of random numbers.

However, this is incorrect. The current functionality of the Randomize statement in Visual Basic, Applications Edition, is the same as in the Basic, Visual Basic, and QuickBasic languages. The Randomize statement does not reset the seed for the Rnd function.

WORKAROUND

To re-initialize the random-number generator, use the Rnd function with a value of -1 to re-initialize the Rnd function, and then use the Randomize statement with the value you want to use as the seed value for the Rnd function. The following is an example of using this method:

Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.
 (閱讀全文)

Emily | 24th Dec 2005, 21:30 PM | Network / Media | (1087 Reads)

列出 IE 開啟中的 URL (2)

以下編碼可列出 IE 連接中的 URL,需引用 Microsoft Internet Controls

 (閱讀全文)

Next