Attachment list in a PMO

[former_member279043]

I need to retrieve all the attachment file names out of a list of PMO's.  I can macro to get to the attachment list, but how do I pull the names in?

I got here and could not get it to work.

session.findById("wnd[0]").maximize

session.findById("wnd[0]/titl/shellcont/shell").pressContextButton "%GOS_TOOLBOX"

session.findById("wnd[1]/usr/tblSAPLSWUGOBJECT_CONTROL/txtSWLOBJTDYN-DEF_ATTRIB[1,0]").caretPosition = 12

session.findById("wnd[1]").sendVKey 2

session.findById("wnd[0]/titl/shellcont/shell").selectContextMenuItem "%GOS_VIEW_ATTA"

session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").currentCellColumn = "BITM_DESCR"

session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").selectAll

session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").pressToolbarContextButton "&MB_EXPORT"

Session.findById("wnd[1]/usr/cntlCONTAINER_FILENAME").Text = "test.xls"

                    Session.findById("wnd[1]/usr/cntlCONTAINER_0100_FILENAME").caretPosition = 14

                    Session.findById("wnd[1]/tbar[0]/btn[11]").press

session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").selectContextMenuItem "&XXL"

[stefan_schnell · Accepted solution]

Hello Kevin,

you can get the content of the Title column from the Generic Object Services (GOS) with this tiny stub:

session.findById("wnd[0]/titl/shellcont/shell").pressContextButton _

  "%GOS_TOOLBOX"

session.findById("wnd[0]/titl/shellcont/shell").selectContextMenuItem _

  "%GOS_VIEW_ATTA"

Set Atta = session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell")

TitleCol = Atta.ColumnOrder().Item(1)

For i = 0 To Atta.RowCount() - 1

  MsgBox Atta.GetCellValue(i, TitleCol)

Next

Let us know your result.

Cheers

Stefan

[former_member279043]

That was what I needed.  Thank you!

[script_man]

Hi Kevin,

I would record my own script, allowing it to work.

Regards,

ScriptMan