OLEObject ole_object
// Create or "Instantiate" the ole_object variable
ole_object = CREATE OLEObject
IF [login to view URL]("excel.application.8") = 0 THEN
? ? ? ? [login to view URL] = "False"
? ? ? ? [login to view URL](IS_SPREADSHEET) //Open the .xls file
Else
? ? ? ? MessageBox('OLE Error','Unable to start an OLE server process!',Exclamation!)
END IF
// Make Object Invisible
ole_object.Visible=FALSE
//CSV File name
ls_file = "c:\temp\[login to view URL]"
FileDelete(ls_file)? ? ?
// I am able to start the excel spreadsheet using similar code with ole controls. What I need is a macro or command to do the update links command. I can write a macro to update linked spreadsheets? and i would like to call it from my script above. My application writes out data to a spreadsheet that is? linked to another spreadsheet with report formats.?
I want to update the? cells auto from the linked ss after the ss is written with data. I am missing the small lines of code to do this.
Can anyone help.
I'll pay a small amount for the? answer.?
// Saves the document to another filename
[login to view URL](ls_file, 6)? ? //csv
//[login to view URL](ls_file, -4158) //text tab delimited
[login to view URL] = "False"
[login to view URL]()
// Disconnect from Excel
[login to view URL]()
// Destroy the Ole Object
DESTROY ole_object