You can write script in Visual Basic or build an application (written in
C++) and You have to use OLE. Just look at Excel & Visual Basic help.
RS-232 port is supported by instructions:
OpenFile(.....) - open RS port
CloseFile(...) - close port
ReadFile(...) - read data from port buffer
WriteFile (...) - write data to port buffer
Below there are few lines of code (C++) that open excel from application and
add workbook.
Variant XL,v0,v1,v2, v22,
my_point,my_series,my_cell,my_workbooks, my_worksheets,
my_range,Xrange,Trange,Urange,Irange,Qrange,cell1,cell2,
WD,a,b,c,tt;
XL=CreateOleObject("Excel.Application");
XL.OlePropertySet("Visible",true);
my_workbooks=XL.OlePropertyGet("Workbooks");
my_workbooks.OleProcedure("Add"); // <- do tego jest OK
v1=my_workbooks.OlePropertyGet("Item",1);
v0=v1.OlePropertyGet("Worksheets") ;
P.S. Sorry for my english.
Grzegorz