香港新浪網 MySinaBlog
Emily | 30th Jul 2008, 14:27 PM | Excel 2007 | (2945 Reads)

Excel 2007 與 2003 中顯示的顏色不一至

Excel 2007中編輯好的檔,其中背景顏色(圖案顏色)為綠色,到了另外幾台電腦中用2003打開時卻顯示為黃色。 不知道用什麼辦法才能讓 Excel 2007 與 Excel 2003 中顯示的顏色一至? 

 

 (閱讀全文)

Emily | 22nd Jul 2008, 12:54 PM | 雜談 | (1465 Reads)

 chijanzen 的雜貨鋪

Chijanzen 的個人網站停了頗長的時間,偶然遇上,舊雨新知請訪問一下

停了2年,從新出發的網站

本人因為工作停了2年的網誌,終於偷偷的複站了
選上了 Wordpress 重新出發,喜歡我的網誌的請加連結
路過的也感謝你參觀

http://chijanzen.net/wp/


Emily | 19th Jul 2008, 11:50 AM | Excel 2007 | (954 Reads)

"InsertPic" Excel 2007問題

2003運行完全沒問題的 , 但2007就運行不能了

Question

 (閱讀全文)

Emily | 1st Jul 2008, 12:37 PM | Excel 2007 | (2873 Reads)

Use VBA SaveAs in Excel 2007

 Information

If you run the code in Excel 2007 it will look at the FileFormat of the parent workbook and save the new file in that format.
Only if the parent workbook is an xlsm file and if there is no code in the new workbook it will save the new file as xlsx,
If the parent workbook is not an xlsx, xlsm, or xls then it will be saved as xlsb.

This are the main formats in Excel 2007 :

51 = xlOpenXMLWorkbook (without macro's in 2007, xlsx)
52 = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm)
50 = xlExcel12 (Excel Binary Workbook in 2007 with or without macro’s, xlsb)
56 = xlExcel8 (97-2003 format in Excel 2007, xls)

More details and examples: http://www.rondebruin.nl/saveas.htm

 

 (閱讀全文)