| john nairn 2004-09-28, 3:55 am |
| Hi,
In an ole application I need to be able to specify which of several
copy of excel running on a computer is the target for ole data being
output to a new excel spreadsheet. Before each line is output I would
like to use a handle to point the application to just one copy of
excel.
I have an application that dumps data to excel spreadsheets. It uses
prop:createole to make a object then prop:create to make a new excel
spreadsheet. The application is souce code with now window or report
layout. It uses higly hand coded interface objects to get the required
data from sql, so I do not want to use any of the standard excel
report tools if I can help it.
It works fine unless the user opens another Excel spredsheet. Once a
second copy of Excel is opened on the desktop all the OLE data dumps
into the second spreadsheet. Open a third copy of excel and data
starts flowing to the third copy. As uses change the focus the top
copy of excel starts getting the rest of the data. I need the data to
flow to the copy of excel opened by the application, not one opened by
the user.
Thanks for your help.
|