I was wondering if there is another way to connect to and populate an Excel spreadsheet other than the way below...
// Create the oleobject variable xlapp
lole_xlApp = Create OLEObject
// Connect to Excel and check the return code
li_return = lole_xlApp.ConnectToNewObject( "Excel.Application" ) // "Excel.Sheet"
if li_return < 0 then
MessageBox("Connect to Excel Failed !",string(li_return))
// Open a particular Excel file
** A lot of magical code here **
// Save opened file
Our clients are complaining that this process takes to long but I do not know of another way to use PB and Excel.
On a side note we will be upgrading to PB2017 hopefully this week.
Any help would be appreciated.