-
Notifications
You must be signed in to change notification settings - Fork 14
/
VA03ExtractItemList
43 lines (42 loc) · 1.81 KB
/
VA03ExtractItemList
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Sub sales_order_va03()
Set SapGuiAuto = GetObject("SAPGUI") 'Get the SAP GUI Scripting object
Set SAPApp = SapGuiAuto.GetScriptingEngine 'Get the currently running SAP GUI
Set SAPCon = SAPApp.Children(0) 'Get the first system that is currently connected
Set session = SAPCon.Children(0) 'Get the first session (window) on that connection
session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").Text = "/nva03"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/ctxtVBAK-VBELN").Text = "7776376"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/tabsTAXI_TABSTRIP_OVERVIEW/tabpT\02").Select
Set items = session.findById("wnd[0]/usr").FindByNameEx("SAPMV45ATCTRL_U_ERF_AUFTRAG", 80)
total_items = items.verticalScrollbar.Maximum + 1 '
If total_items = 0 Then
total_items = 1
End If
PageSize = items.verticalScrollbar.PageSize
items.verticalScrollbar.Position = 0
Cells(1, 1) = "Item"
Cells(1, 2) = "Material"
Cells(1, 3) = "Qty"
Cells(1, 4) = "UOM"
Cells(1, 5) = "Desc"
For j = 1 To total_items
pageindex = j Mod PageSize
If pageindex = 1 Then
If j > 1 Then
session.findById("wnd[0]/tbar[0]/btn[82]").press ' click the next page button
Set items = session.findById("wnd[0]/usr").FindByNameEx("SAPMV45ATCTRL_U_ERF_AUFTRAG", 80)
End If
CurrentRow = 0
Else
CurrentRow = CurrentRow + 1
End If
Set cur_row = items.Rows(CurrentRow)
Cells(j + 1, 1) = cur_row(0).Text
Cells(j + 1, 2) = "'" + cur_row(1).Text
Cells(j + 1, 3) = "'" + cur_row(2).Text
Cells(j + 1, 4) = "'" + cur_row(3).Text
Cells(j + 1, 5) = "'" + cur_row(5).Text
Next j
End Sub