[Solved] How close document?

[hardegor]

I'm open document .xls, successfully read text and .... how close document?
Next, I need to open the next .xls, etc.

My code:

Code: Select all

	Dim args()	
	Set SM= CreateObject("com.sun.star.ServiceManager")	
	Set Desktop= SM.createInstance("com.sun.star.frame.Desktop")	
	currentfilename = "file:///T:/CD2.xls"
	Set objCalc= Desktop.loadComponentFromURL(currentfilename, "_blank", 0, args)
	Set objWorkSheet= objCalc.Sheets.getbyName("Sheet1")
	Set objCell= objWorkSheet.getCellbyPosition(0,3)
	Print objCell.getFormula()

[FJCC]

Call the close() method of your objCalc. See close.
Note that you have to set the parameter DeliverOwnership to either True or False.

[hardegor]

Ou, thanks! It's work! :=)
It is a pity that, the documentation for each object or method is not listed small snippets examples...

[FJCC]

Use object inspection tools like MRI or XRay to find the methods and properties of any object.