我的程式碼如下 :  

 
  CoInitialize(nil);
  Excel:=CreateOleObject('Excel.Application');
  Try
    .
    .
    .
    ShowMessage('Excel 檔輸出完成 !!');
  Finally
    Excel.Quit;
    VarClear(Excel);        CoUnInitialize;
  end;

但是程式執行到 CoUnInitialize; 時會出現 "Access violation" 的錯誤 請問這是什麼原因呢? 另, 為什麼有時候在 Excel:=CreateOleObject('Excel.Application'); 之前可以不用呼叫初始化函數也不會有問題, 而有時候則必須要先呼叫初始化函數, 否則會出現 "Moniker並未參照到存放庫" 的錯誤訊息?? 請各位先進不吝為小弟解惑.. 謝謝 !!

引言: 我的程式碼如下 :

 
  CoInitialize(nil);
  Excel:=CreateOleObject('Excel.Application');
  Try
    .
    .
    .
    ShowMessage('Excel 檔輸出完成 !!');
  Finally
    Excel.Quit;
    VarClear(Excel);        CoUnInitialize;
  end;

但是程式執行到 CoUnInitialize; 時會出現 "Access violation" 的錯誤 請問這是什麼原因呢? No idea. But if Excel is a local variant variable, I think you should leave it alone since the proecdure will destroy it at the end. Try removing the line "VarClear(Excel)" and probably the CoInitialize and CoUnitialize if you are not using COM within a thread. 另, 為什麼有時候在 Excel:=CreateOleObject('Excel.Application'); 之前可以不用呼叫初始化函數也不會有問題, 而有時候則必須要先呼叫初始化函數, 否則會出現 "Moniker並未參照到存放庫" 的錯誤訊息?? Because the related units you probably used (e.g. COMObj) has the proper initialization/finalization section to do all the works for you. However, if you want to use COM within a thread (except main thread), you need to do it yourself. 請各位先進不吝為小弟解惑.. 謝謝 !!