Using current excel open file to send data

P

pablo-ativa

New Member
Hello,

I want to make an open excel file send some data (variables) to a .p program.
The xls file must be already open by user e not by progress. I want to click a button and run a .p that connect with this excel session already open and get data from the worksheet.

msn online help will be great
tks a lot and excuse me for my bad english.

Pablo
e-mail/msn: pablo@ativa-qi.com.br
 
Pablo, Try the following: Create an excel file in c:\ and name it as 'test.xls'. Run the following code in progress procedure editor: DEFINE VARIABLE excelAppl AS COM-HANDLE. CREATE "Excel.Application" excelAppl. excelAppl:Visible=true. excelAppl:Workbooks:OPEN('c:\test.xls'). RELEASE OBJECT excelAppl.
 
You must log in or register to reply here.
Back
Top