9. Excel Macros (VBA) - Analysis for Office (A4O) Automation (SAP BW)

Video shows on how we can automate SAP BW reports in Analysis for Office (A4O) within excel with the help of excel macros magical code

[@marlongonzalez823]

Very helpfull video and very straight foward explanation. Thank you for this!

[@jideade1207]

Thanks for this, spent hours in trying to automate some data refresh!

[@pawekok7887]

Did you find a way to connect SAP by VBA to the skip popup logon window "logon to SAP business objects BI Platform" ?

[@jideade1207]

@@pawekok7887oh I’m usually logged in SAP Analysis for office before running the VBA code.

[@giftsonpaul2159]

Want more videos

[@icarogillead4654]

Thanks for this video! What if I want to call the dates from particular Excel's cells? Like H2, let's say.

[@kaseox5436]

Hi, thank you it is really working. How we can automate next stepts e.g. in display in rows there is variable "Contact ID" and I would like to paste there some numbers

[@aprilbuenaventura7479]

Hi, thanks for sharing, very helpful! I have two reports in one sheet, it updates both at the same time with the refresh command. However I want to have a filter updated in the 2nd report based on the 1st report that was updated. Is this possible to add to a vba command? Thanks!

[@prashanthkumboji9260]

What type should refresh,a,b,c needs to be declared?

[@SuccessSyapa]

Thanks for the video tricky world, however in my AO report, whenever i'm closing the excel file and re-opening it. It's connection with SAP is lost and if i try to refresh it, it don't get re-fresh and show a connection error with sap. Therefore i have to create the report agian. Please provide solution for the same

[@trickyworld9152]

Hey Alisha, thankyou for ur msg! Could u share with us snapshot of the message or error u r getting while trying refresh ...

[@adrianlandwonski9420]

Could you please help me with these steps? I don't know where to start..

[@riccil5355]

Which Library in VBA is necessary use?

[@PauloSantos-bk3xm]

Great video man! However, the code is not working when I try to apply it to a brand new workbook with only one BW Report as well as in your example. It comes with the below error: Run-time error '424': Object required Additionally, how could I apply it to a workbook with several BW Reports in different sheets? Thanks in advance

[@prashanthkumboji9260]

Same here

[@paweidzikowski5064]

hello, Could you help to clarify how should I set the data If format is weekly ?

[@paweidzikowski5064]

@trickyworld9152

[@praneshjayakumar1671]

Hi bro.. I run same code from vba.. But not working

[@trickyworld9152]

Could you share code details or statement which is not working

[@praneshjayakumar1671]

@@trickyworld9152 sure

[@kukki619]

How can we log in using VBA With our credentials