Open Excel, run macro, save and close

Hi,

I've asked this before and now I have the same problem.

I have code like this but macros are not run when it update excel. If I open same xlsm manually macros run just nicely.

Dim oNewVerObjAndProps
	Set oNewVerObjAndProps = Vault.ObjectOperations.CreateNewSFDObject(MFBuiltInObjectTypeDocument,oPropertyValue, oSourceFile, false, Nothing)
	
	Vault.ObjectFileOperations.UpdateMetadataInFile oNewVerObjAndProps.ObjVer, -1, True
	Dim oNewObjectFiles: Set oNewObjectFiles = Vault.ObjectFileOperations.GetFiles(oNewVerObjAndProps.ObjVer)
	If oNewObjectFiles.Count > 0 Then
	  Dim n
	 
	  For n = 1 To oNewObjectFiles.Count
	    Dim oNewObjectFile: Set oNewObjectFile = oNewObjectFiles.Item(n)
	  Next
	End If
	
	Vault.ObjectFileOperations.ConvertToPDF oNewVerObjAndProps.ObjVer, oNewObjectFile.ID, False, True, True, True
	Vault.ObjectOperations.CheckIn(oNewVerObjAndProps.ObjVer)

Reason for macro is to adjust rowheight. Is there any other way of doing the same?

Cheers

Petteri