下列程式碼會將WorkSheet 加在最前面,請問要用什麼指令才可加在最後的位置(編號最後一個WorkSheet)?? 請指教,THANKS! #include "ComObj.hpp" #include "Excel_2K_SRVR.h" Variant ExcelApp, ExcelBooks, ExcelBook, ExcelSheets, ExcelSheet; ............ ............ ExcelSheets=ExcelBook.OlePropertyGet("Worksheets"); ExcelSheet=ExcelSheets.OleFunction("Add"); // AnsiString szSheetName="MySheetName"; // ExcelSheet.OlePropertySet("Name", StringToOleStr(szSheetName)); 發表人 - ttk 於 2004/11/12 18:01:12

try this: ExcelSheets=ExcelBook.OlePropertyGet("Worksheets"); Count=ExcelSheets.OlePropertyGet("Count"); LastSheet=FApp.OlePropertyGet("WorkSheets", Count); ExcelSheet=ExcelSheets.OleFunction("Add", Null(), LastSheet); Allen Chan

Hi! Allen, I use Null() command ,but compiling is not success. I change this line as: ExcelSheet=ExcelSheets.OleFunction("Add", LastSheet); then the new sheet(ExcelSheet) is added before the LastSheet. I will try it until I succeed, or you have another suggestion! many tks! Bill

請問您的錯誤訊息為何？ 我用 C Builder 6 來 Compile 這段程式碼是 OK 的。 或許你試試看： Variant vNull; vNull.VType = varNull; .... ExcelSheets.OleProcedure("Add", vNull, LastSheet);

在C builder5 錯誤訊息為: Call of nonfunction, 是否要 #include ??? 無論如何,按照你的新方法,已可compile且執行成功! 謝謝!