Code Comments
Programming Forum and web based access to our favorite programming groups.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.
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.