香港新浪網 MySinaBlog
Emily | 29th Sep 2005, 19:59 PM | Office Application | (1447 Reads)

Export PPT Notes to text

 

 (閱讀全文)

Emily | 29th Sep 2005, 04:20 AM | 雜談 | (671 Reads)

一匹馬和一隻青蛙

一隻青蛙和......一匹馬......

請您仔細看,其實二幅是同一張圖,

聰明的您看出了嗎?

 (閱讀全文)

Emily | 28th Sep 2005, 18:58 PM | Network / Media | (918 Reads)

Excel 攝取 Outlook GAL

GAL = Global Address List

'

 (閱讀全文)

Emily | 27th Sep 2005, 17:12 PM | General | (4018 Reads)

Su-doku puzzles (also spelt Sudoku) are 9x9 grids of numbers, subdivided into 3x3 blocks. When you begin a puzzle, some of the numbers are already filled in, and you have to fill in the blank squares using logic. You must fill the grid so that all the numbers 1-9 appear in each row, column and 3x3 box. However, no row, column or 3x3 box may have two of the same number.

Su-doku puzzles first appeared in New York in the late 1970's under the title "Number Place". They were introduced to Japan in 1984 where they were renamed to Su-doku (pronounced sue-do-koo; su = number, doku = single), so su-doku translates as "single number".

Su-doku is now more popular than ever, especially in the UK where puzzles are appearing daily in all the major newspapers and magazines.

http://www.su-doku.net/

9 x 9 的有沒有玩過,現在已有 16 x 16 的,高難度!!!

以下連結有很多資料如 sudoku 產生器,Excel 板也有但沒有解法。

http://sudoku.heebie.co.uk/index.php?option=com_frontpage&Itemid=1

 

More about Sudoku Added on 8 Jan 2006


Excel 有解嗎?

 

 (閱讀全文)

Emily | 27th Sep 2005, 12:50 PM | General | (11058 Reads)

Excel 欄寬

ColumnWidth property 是 CPI,我使用中 Excel 的欄寬預設為 8.38,即是一個 Cell 內容許 8.38 字。

Cell("Width"), 儲存格欄寬四捨五入後的整數值。每一個欄寬單位與預設字型的一個字元的寬度相等。

欄寬可以利用 point 設定 (VBA):

.ColumnWidth = 36 / .Columns(1).Width * .Columns(1).ColumnWidth

欄寬可以利用 cm 設定 (VBA):

Columns(12).ColumnWidth = CDbl(Columns(12).ColumnWidth / Columns(12).Width * Application.CentimetersToPoints(0.5))

 

 (閱讀全文)

Emily | 26th Sep 2005, 17:46 PM | WB & WS | (4040 Reads)

Excel 儲存格文字變色例子

Changing Font Color

 (閱讀全文)

Emily | 26th Sep 2005, 14:25 PM | WB & WS | (1783 Reads)

在單元格插入相片

這示例將一幅小於 409 點高度 (Excel 的限制) 的相片插入儲存格 A1 並自行調節 A1 高度。

 (閱讀全文)

Emily | 25th Sep 2005, 01:28 AM | WB & WS | (4256 Reads)

怎樣將選定內容複製到圖表並導出JPG檔

原問題

請各位大哥指教一下,EXCEL選定範圍的內容,如(A1:D5),以圖形方式粘貼到圖表chart中,就相當於局部螢幕拷貝後粘貼。ActiveSheet.Range("A1:D5").CopyPicture Appearance:=xlScreen, Format:=xlPicture 這一句是起螢幕拷貝功能,我有一點懂。但是用charts.add 增加一個圖表後,怎樣把拷貝的圖形粘貼上去呀,語句怎麼寫。還能控制圖表的大小,使它恰好適應所拷貝圖形的大小嗎?

 (閱讀全文)

Next