SAP data extraction with multiple macros

[Franz68]

Hi all,

I'm retrieving data from the SAP Erp system using a main macro that calls several macros, using a structure like this:

sub Main()

call Macro1 'get parameters from the Excel worksheet
call Macro2 'input some basic parameters in SAP
call Macro3 'get first data from a SAP transaction
call Macro4 'get first data from another SAP transaction
call Macro5 'get first data from another SAP transaction

end sub

My problem is that the execution stops after the first data are retrieved from SAP, so at the end of Macro3.

The only way I found until now, is to insert in any subsequent macro (I'm retrieving data from more than 2 SAP transactions...) the check if the data needs to be retrieved or not (there are checkboxes on the worksheet to tell Excel which report needs to be downloaded).
But this is increasing the number of code lines...

There is anyone there that has better ideas?

Thanks a lot in advance

Ciao from Berlin
Franz

 

[Franz68]

I found the solution... I was, encapsulating the macros to call the transactions in a If... elseif... series, due to copy from a previous version that was using VBScripts to call the transactions... But now every macro needs to be enclosed only in an If... end if.

Ciao
Franz