Hi,
Is it possible to fill the author, Title and other property-fields of an excel-file via FiveWin?
Thanks
Marc
When I do not know how to do something in Excel I record a macro, make the changes, then go back and edit the macro to see how Excel did it.
The problem is that a macro doesn't record changing the title or author.
Marc
That does make it harder 
I will check.
Dim properties As Microsoft.Office.Core.DocumentProperties
properties = DirectCast(Globals.ThisDocument.BuiltInDocumentProperties, _
Microsoft.Office.Core.DocumentProperties)
properties.Item("Subject").Value = "Whitepaper"
oWorkBook:BuiltinDocumentProperties("Author") := cAuthor
oWorkBook:BuiltinDocumentProperties("Title") := cTitle
oWorkBook:BuiltinDocumentProperties("Comments") := cCommentsError description: Error Excel.Application:ACTIVESHEET/16389 E_FAIL: _BUILTINDOCUMENTPROPERTIES
Args:
[ 1] = C Test
Stack Calls
===========
Called from: win32ole.prg => TOLEAUTO:_BUILTINDOCUMENTPROPERTIES(0)
#include "FiveWin.ch"
Function Main()
Local oExcel,oWorkBook
oExcel:=CreateObject( "excel.application" )
oWorkBook:=oExcel:Workbooks:Add()
oWorkBook:BuiltinDocumentProperties("Author"):Value := "Anser K.K."
oWorkBook:BuiltinDocumentProperties("Title"):Value := "Test Title"
oWorkBook:BuiltinDocumentProperties("Comments"):Value := "Test Comments"
cFile := 'D:\test.xlsx'
oWorkBook:saveAS( cFile )
oExcel:Quit()
MsgInfo("Done")
Return NilThanks Anser,
It's working fine now!!
Regards,
Marc