My code refreshes the data but doesn't update the values in the prompt (meaning the table doesn't change, as it was already showing the result of the old prompt) :( I don't get any error message... any ideas on how to fix it? My code is exactly the same as shown in the video (with my technical fields, of course). If my company had any restrictions, I'd assume it wouldn't allow the refresh, but that's not the case...

Want more videos

Can i make this new session ?

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

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

Hi, do you have a video for VA01 automation?

Which Library in VBA is necessary use?

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!

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

varient is the easier way

Hi when I press ok to prompt - sap scripting is attempting to access SAP GUI it does not run Sap

Very useful for me, Thanks a lot from Thailand

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

What if two different SAP systems are open, How excel will know which one to user ?

when ever I am executing the macros script on sap screen . I wont have control over the mouse . Is there any way that i can perform any other activity on laptop while macros script is running on background ?

How to set date from - to in excel and what's the code i have to add ?

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

Dear Thank you for this Video, My requirement is, i want to Automate the Excel to be executed in certain frequency i.e. daily and irrespective of whether the SAP is running or not. Please, guide me with this script

best content

please change the colour of Excel

very very useful

I am using sap 770 login but unable to find record scripting

Many thanks!

Hi, Thank you for your video:) I am trying to extract data from SAP but for current dates. For example; if I run the macro on Monday it should pick up data until Monday qnd the same for any other day. Could you please assist me in this regard. Thank you

Hi, this will work only if SAP is login

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

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

Hello, I would like to copy paste 17 vendor codes at a time and along with loop as there is a task to upload 7000 vendor codes in a t code but in SAP we only can paste 17 codes in a shot n then use page down for updating others codes n so on, so could u please tell me how to do this,,, any suggestions plz

nice one, do you have a contact number to help me out. let me know your charges please if you can

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

Hello, I have the start date and end date in the script I'm working on. I want to do the start date from Sunday and end date Saturday for next week. How can this be done can you assist?

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

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

Hi tricky world, It's good to have you videos, I have small doughts on SAP GUI can you please give ur phone number to reach you

Excellent 👌

Hey, Iam facing a "runtime error '6' Overflow". Can you give me a solution?

Great video but we need more Aap gui scripting videos 🎥 Or else could please make one comprehensive video on SAP gui scripting

Out standing explanation please make more videos like this I really😊 like it....

Hey bro nyc video iam also using sap gui scripting

Good night, how are you? I'm trying to make a column macro that can copy the right values ​​from column A based on the values ​​in B and when the value changes to copy and continue following the Script. Detail, the values ​​of column A will be repeated. Could you tell me how to modulate this code? For example: column a column b 1440 24357 1441 24357 1442 24357 1443 24357 3166 43512 When we get to line 5 where it continues the rest of the code written by the script and when we do it continue from the line where it left off. You help me a lot. Thanks in advance.