VBA and SAP issue

[GordonKy42]

Hey All,

I am trying to automate a process as it is been ran daily, i want to use task scheduler to run this and send out a report.

My issue is this I run one report in SAP it leaves a pop up box in the SAP window saying to save the data in the spreadsheet, i have the vba closing this pop up once i have copied over the report. This box is meaning when i try to link into the next report it will error out.

Save.GIF

How can i open a new SAP window and run the next one from there, or open two to begin with then close this one?

Trying to run the SUBs 'SAPRUN' then 'zhwc'

Any help is greatly appreciated

Cheers

[GordonKy42]

Hello all,

I managed to solve this one myself by adding in the following code to the end

Workbooks("Worksheet in detcap (1)").Close SaveChanges:=False
' close SAP pop up menu and return to main screen, the pond
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[0,0]").Select
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[0,0]").SetFocus
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
Exit Sub