Excel Buffer/Automation

Hohenzollern

Hi to all

Can someone explain me please, how to use Automation? For example I have such simple code (using excel buffer, as u see).

WITH ExcelBuffer DO BEGIN
RESET;
DELETEALL;
SETRANGE("No.",Rec."Accountable person");
NewRow;
AddColumn('First Name',FALSE,'',FALSE,FALSE,FALSE,'');
AddColumn('Middle Name',FALSE,'',FALSE,FALSE,FALSE,'');
AddColumn('Last Name',FALSE,'',FALSE,FALSE,FALSE,'');
CreateBook();
CreateSheet('Sheet 1','Report',COMPANYNAME,USERID);
GiveUserControl();
END;

How can I do the same using Automation? I was looking through the forum but didn't find what can help me. Thx for any links.

kine

It is not clear what you mean by "using Automation"... the used functions are using the Excel automation libraries to do the export. What you want to know more? Just look into the functions what they are doing...

DenSter

Take a look at the code in the Excel Buffer table, that is where the actual automation takes place.

Hohenzollern

I was talking about smth like 'Microsoft Excel 14.0 Object Library'. Just cannot find simple examples of how to use it's functions. But I succeed) Thx for your answers.
Anyway, If there is still something I can learn/read, mb some basics, I will be glad to see them. Best regards.

DenSter

I know what automation is. Take a look at the code in the Excel Buffer table, that is where you will find the actual automation code. For instance in the CreateBook function, you will find the code to instantiate the Excel application, and a reference to the methods of this variable.

geschwint

This is the documentation I use whenever I'm in need of doing something with Excel or Word in C/SIDE: http://docs.softartisans.com/officewrit ... ppobj.aspx