Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Obtain in SAP an excel Author (the file creator)

0 Kudos

Hi experts!

I need to obtain the file author when I make an excel upload. We can found the file author at the file properties (menu: file/properties) or rigth click and properties.

tks!

Adr!

7 REPLIES 7

Former Member
0 Kudos

I can't find an example, but I would guess that you could obtain via OLE.

0 Kudos

Do you know how? I looked for an excel method but I could not found it.

thks anyway

0 Kudos

Using google "vba excel properties author", I could easily find the answer ([here|http://vbadud.blogspot.com/2007/05/retrieve-file-properties-vba.html]):


Dim oWB As Workbook
Set oWB = ActiveWorkbook
sAuthor = oWB.BuiltinDocumentProperties("Author").Value

I let you translate into ABAP OLE2, or ask us if you can't.

0 Kudos

Hi!

Thank you for the answer, but I can't make it work. Can you help me please?

how can I do?

tks!!

Adr!

0 Kudos

> Thank you for the answer, but I can't make it work

as usually, tell us what is the symptom ?

0 Kudos

Resolved:

get property of lw_activedocument 'Application' = gs_application .

call method of lw_activedocument 'BuiltinDocumentProperties' = lw_documentproperties

EXPORTING

#1 = 'Author'.

get property of lw_documentproperties 'Value' = lv_userid .

tks!!

0 Kudos

and thank you for the abap code