香港新浪網 MySinaBlog
Emily | 28th Feb 2006, 11:06 AM | WB & WS | (7359 Reads)

Excel 閱讀超過 65536 行

組合 (Combination) 有一 Dos 程式連結,有朋友詢問可否用 Excel 閱讀超過 65536 行,ADO 例子:

 

 (閱讀全文)

Emily | 28th Feb 2006, 10:24 AM | General | (811 Reads)

List of Locale ID (LCID) Values as Assigned by Microsoft

The purpose of the document is to help developers who are defining NLS services (sorting, time/date formatting, and keyboards/IMEs) for locales that do not yet have native support in Windows to avoid conflict.

http://www.microsoft.com/globaldev/reference/lcid-all.mspx


Emily | 22nd Feb 2006, 15:20 PM | WB & WS | (2492 Reads)

Application.CommandBars("Task Pane")

以下句子在 Excel 開始時沒有 TaskPane 是不可以執行的
i.e 默認值沒有 TaskPane
   
Private Sub Workbook_Open()
    If Application.CommandBars("Task Pane").Visible = False Then
        Application.CommandBars("Task Pane").Visible = True
   
End If
End Sub
 
  
 (閱讀全文)

Emily | 21st Feb 2006, 10:51 AM | Network / Media, Office Application | (1430 Reads)

列出 HTML 部份原始碼

 WinHttpRequest

 

 (閱讀全文)

Emily | 19th Feb 2006, 12:28 PM | General | (621 Reads)
Free Video Tutorials (English)


http://www.datapigtechnologies.com/


Emily | 14th Feb 2006, 11:51 AM | General | (929 Reads)

Methods In Excel (推介 Excel 例子網页)

http://www.methodsinexcel.co.uk/articles.html

Playing a video on userform         emoticon


Emily | 13th Feb 2006, 12:56 PM | General | (563 Reads)

一個編碼編輯 (儲存) 工具 ConText

ConTEXT is a small, fast and powerful freeware text editor, developed mainly to serve as secondary tool for software developers.

多語言板 http://www.context.cx/

 


Next