开发者

How to add a button to Excel with OLE

开发者 https://www.devze.com 2023-04-02 05:44 出处:网络
I use OLE method like this: var xlApp, xlWorkBook, xlWorkSheet, arr: Variant; begi开发者_如何学Cn

I use OLE method like this:

var   
  xlApp, xlWorkBook, xlWorkSheet, arr: Variant; 
begi开发者_如何学Cn   
  xlApp := CreateOLEObject('Excel.Application');   
  xlApp.Visible := True;    
end; 

How to add a button to Excel?

And how to assign a exist marco on this button?

Where can I find Delphi-OLE-Office document?

Thx.


I worked this out by recording a VBA macro and then pasting it into your Delphi routine:

xlApp := CreateOLEObject('Excel.Application');
xlApp.Visible := True;
xlWorkBook := xlApp.Workbooks.Add;
xlWorkBook.ActiveSheet.Buttons.Add(10, 10, 80, 30).Select;
xlWorkBook.Selection.OnAction := 'Macro1';

There is no Delphi documentation of Office COM automation. You have to use the MSDN documentation and translate it into Delphi yourself.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号