Variant Excel,Workbooks,Workbook;
Excel=CreateOleObject("Excel.Application");
Excel.OlePropertySet("Visible",true);

引言: 各位大大: 請問一下,我參考了 http://delphi.ktop.com.tw/topic.php?topic_id=22668 的程式,我只打了前面三行

Variant Excel,Workbooks,Workbook;
//Excel=CreateOleObject("Excel.Application");
改成Excel=Variant::CreateObject("Excel.Application");
Excel.OlePropertySet("Visible",true);

就出現了下面的錯誤, [Linker Error] Unresolved external '__stdcall System::Variant::OlePropertySet(const System::AnsiString&, TAutoArgsBase&)' referenced from C:\PROGRAM FILES\BORLAND\CBUILDER5\PROJECTS\UNIT1.OBJ 請問有人知道為什麼嗎??? 我的環境是 Win2k BCB5.0 謝謝各位大大.....

引言: 各位大大: 請問一下,我參考了 http://delphi.ktop.com.tw/topic.php?topic_id=22668 的程式,我只打了前面三行 Variant Excel,Workbooks,Workbook; //Excel=CreateOleObject("Excel.Application"); 改成Excel=Variant::CreateObject("Excel.Application"); Excel.OlePropertySet("Visible",true); 就出現了下面的錯誤, [Linker Error] Unresolved external '__stdcall System::Variant::OlePropertySet(const System::AnsiString&, TAutoArgsBase&)' referenced from C:\PROGRAM FILES\BORLAND\CBUILDER5\PROJECTS\UNIT1.OBJ 請問有人知道為什麼嗎??? 我的環境是 Win2k BCB5.0 謝謝各位大大.....

引言:

引言: 各位大大: 請問一下,我參考了 http://delphi.ktop.com.tw/topic.php?topic_id=22668 的程式,我只打了前面三行 Variant Excel,Workbooks,Workbook; //Excel=CreateOleObject("Excel.Application"); 改成Excel=Variant::CreateObject("Excel.Application"); Excel.OlePropertySet("Visible",true); 就出現了下面的錯誤, [Linker Error] Unresolved external '__stdcall System::Variant::OlePropertySet(const System::AnsiString&, TAutoArgsBase&)' referenced from C:\PROGRAM FILES\BORLAND\CBUILDER5\PROJECTS\UNIT1.OBJ 請問有人知道為什麼嗎??? 我的環境是 Win2k BCB5.0 謝謝各位大大.....

paf 你好: 雖然解決了上面的問題,但出現了更多的 error...如下 [C Error] sysvari.h(2561): E2450 Undefined structure 'TAutoArgs<1>' [C Error] sysvari.h(2561): E2449 Size of 'args' is unknown or zero [C Error] sysvari.h(2561): E2450 Undefined structure 'TAutoArgs<1>' [C Error] sysvari.h(2562): E2094 'operator ' not implemented in type 'TAutoArgs<1>' for arguments of type 'int' [C Error] sysvari.h(2563): E2450 Undefined structure 'TAutoArgs<1>' [C Error] sysvari.h(2563): E2285 Could not find a match for 'Variant::OlePropertySet(const AnsiString,undefined)' 但謝謝你的解答....

firewing您好:
 試試下面的方法看看!    #include      Variant vMSExcel;    try {
       vMSExcel = Variant::GetActiveObject("Excel.Application"); 
    } catch (...) {
      vMSExcel = Variant::CreateObject("Excel.Application"); 
    }     vMSExcel.OlePropertySet("Visible", true); 
      |
      |
//處理你想做的事
       |
      | 
vMSExcel.OleFunction("Quit"); 
vMSExcel = Unassigned;     

引言: axsoft 板主: 這樣的話又會發生之前的問題了.... 不過還是謝謝你....

BCB6只要#include 就行了
BCB5還需要#include     //---------------------------------------------------------------------------
#include 
#include 
#include 
#pragma hdrstop    #include "Unit1.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------    void __fastcall TForm1::Button1Click(TObject *Sender)
{
 Variant vMSExcel,vXLWorkbook, vXLWorkbooks;
  vMSExcel = Variant::CreateObject("Excel.Application");
  vMSExcel.OlePropertySet("Visible", true);
  vXLWorkbooks = vMSExcel.OlePropertyGet("Workbooks");
  vXLWorkbook = vXLWorkbooks.OleFunction("Add");
  try
     {
      vMSExcel = Variant::GetActiveObject("Excel.Application");
     }
  catch (...)
     {
     vMSExcel = Variant::CreateObject("Excel.Application");
     }
  vMSExcel = Unassigned;
}
//---------------------------------------------------------------------------

 
  try
     {
      vMSExcel = Variant::GetActiveObject("Excel.Application");
     }
  catch (...)
     {
     vMSExcel = Variant::CreateObject("Excel.Application");
     }

引言: 各位大大...不好意思... 我現在在公司所碰到的問題還是 [Linker Error] Unresolved external '__stdcall System::Variant::OlePropertySet(const System::AnsiString&, TAutoArgsBase&)' referenced from C:\PROGRAM FILES\BORLAND\CBUILDER5\PROJECTS\UNIT1.OBJ 不知有人知道為啥嗎??? 我找了好久都解決不出來...