@@vinit8981 All the code showed in the video You can find in the article on my site (link in the description). I'll keep your comment in mind for the next videos! Thanks for feedback!
it was really awesome. i am wondering if we can bring any table data in excel as per parameter given in excel fields. it will be truly amazing to prepare dashboard.
Yes, it is possible to prepare data in Excel for SAP fields. Create variables, put those values inside and then use them in the SAP recording. Is that what You were asking?
@@SimpleExcelVBA Yes. You are right. But its my bad as sap macro is disabled in my organization. Actually i was trying to make a custom report in excel which will bring open invoice report. So that i can make some bar graph and Pie chart
Simply awesome videos 👍. I often revisit these videos in order to do something else sometimes as the steps explained are divided in a very simple manner so that one can easily customize them.
Looking for vba macros to get the details of meta data from universe in sap BO. (class, objects, columns and tables that are mapped.) Appreciate your help
Thank you very much for your guidance. But when I run the code, there is a Msgbox "A script is attempting to access SAP GUI". Please help me how to reject this warning box?
@@SimpleExcelVBAthank you for your suppor.l have anothor issue , is there any way to close the excel file that exported from SAP ? I real need help with this .
Thanks for your help regarding this, getting the 438 error run time, is that because fo the worksheets reference using Range, Is there any other alternative. Code is working fine. appreciate your help regarding. All worked well except that annoying error
@@SimpleExcelVBA Thank you for responding, my excel is office 365 , 16 version, I am getting Runtime error '438' Object doest support this property or method. I checked every thing with debug did not find any error or warning on code, when I run it does come with 483. Any help will be great
Hi, I am trying to put my connection name in the script but it is showing error. Please help me with this. In the connection name I have to write the name or SID or the group/server
Thanks. I received an error message at the "Set session = Connection.Children(0)" the message was "The enumerator of the collection cannot find an element with the specified index." Is it possible to fix it? SAP opens but is not possible to log in. Thanks again!
@@SimpleExcelVBA I already check Typo, I tried other Index, but there's no login yet. Unfortunatly the Rec and Play Script option is dissable, si I was trying to running from Excel VBA
@@SimpleExcelVBA That's the corp settings I tried to acces to RZ11 transaccion but I received a message, "there's no autorization" However, in options in Script is able.
@@Oscarxxxification If You have no authorization for the specified transaction You can't access it manually or automatically using SAP scripting. But it is weird that You can't connect.
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](http://i.ytimg.com/vi/8nvCW-l2Jdc/mqdefault.jpg)
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](/img/tr.png)
TIME STAMPS
0:00 Intro
0:19 Story of Connect to SAP code
2:18 Code - writing
8:05 Code - testing
9:41 Summary
Is it possible to zoom in the code as font seems to be very small
@@vinit8981 All the code showed in the video You can find in the article on my site (link in the description). I'll keep your comment in mind for the next videos! Thanks for feedback!
Jasny motyw byłby dużo wgodniejszy do oglądania.
Dzięki za info, zmienię na wyraźniejszy w następnym filmie!
it was really awesome. i am wondering if we can bring any table data in excel as per parameter given in excel fields. it will be truly amazing to prepare dashboard.
Yes, it is possible to prepare data in Excel for SAP fields. Create variables, put those values inside and then use them in the SAP recording. Is that what You were asking?
@@SimpleExcelVBA Yes. You are right. But its my bad as sap macro is disabled in my organization.
Actually i was trying to make a custom report in excel which will bring open invoice report. So that i can make some bar graph and Pie chart
Simply awesome videos 👍. I often revisit these videos in order to do something else sometimes as the steps explained are divided in a very simple manner so that one can easily customize them.
Awesome! Glad to hear that :) thank You & enjoy!
This worked perfect for me :).. I was wondering if you can tell us VBA code to log out of SAP... this will really help me..
Check out my article, it will help You with that
simpleexcelvba.com/sap-session-findbyid-10-code-lines-you-can-identify/
Looking for vba macros to get the details of meta data from universe in sap BO. (class, objects, columns and tables that are mapped.) Appreciate your help
I'm sorry, I'm not familair with SAP BO.
Thank you very much for your guidance. But when I run the code, there is a Msgbox "A script is attempting to access SAP GUI". Please help me how to reject this warning box?
Hello, please check my other video about sap scripting pop ups :) ruclips.net/video/iHND_o2H5Bw/видео.html
@@SimpleExcelVBA It's awsome. Thank you very much
Thank you for your amazing vedio, l have a question what is the name of module you used?
Hello, what do You mean? The connection string name?
Yes ,inside "openconnection" function what is the value you pass
@@مريومالعشوان It is the name of the environment I worked in. This is something spefic for the person/company. :)
@@SimpleExcelVBAthank you for your suppor.l have anothor issue , is there any way to close the excel file that exported from SAP ? I real need help with this .
@@مريومالعشوان answer can be found in my another video:)
Awsome, thanks
You're welcome :)
That was really helpful, thank you a lot.
Very nice and really helpful
I have one question what code to change if i am already logon and dont want to logout
Try to use the first part of recorded script :)
Tomas, quick question. do we have to turn on sap gui scripting in reference or this is the late biding option?
This is late binding.
Thanks for your help regarding this, getting the 438 error run time, is that because fo the worksheets reference using Range, Is there any other alternative. Code is working fine. appreciate your help regarding. All worked well except that annoying error
What do You mean? Alternative for Range? --> Cell, I need bigger perspective - the code - to help You :)
@@SimpleExcelVBA Thank you for responding, my excel is office 365 , 16 version, I am getting Runtime error '438' Object doest support this property or method. I checked every thing with debug did not find any error or warning on code, when I run it does come with 483. Any help will be great
looks to be this one, Enter key - is session.findById("wnd[0]").sendVKey 0 ., this is not supported is there alternative to this ?
@@aiwashelo but it comes from the recording or did You manually put that in the code?
@@SimpleExcelVBA coded by watching your video, at the last you had the .sendVKey 0
Hi, I am trying to put my connection name in the script but it is showing error. Please help me with this. In the connection name I have to write the name or SID or the group/server
The name of the environment, the name You manually double click where You want to work in SAP.
Does not work for me. Gets VBA error 1000: "SAP Logon connection entry not found". when it gets to Set Connection = Appl.Openconnection("ISP", _
True)
If You get an error in such case, make sure that "ISP" is a full name of connection/ there is no typo.
can i know more about creating the connection?
What do You need to know? :)
can you upload the xcel file in your tutorial
All the code You can find in the article on SimpleExcelVBA.com, link is in the description :)
Getting 614 error
Without bigger picture I am not able to help You, could You share error description, code and the line when error popped up?
Thanx, for making the code nearly unreadable with this creative color scheme.
Noted that.
Anyway, all the code is under the link in the description, so no worries of missing anything from video! :)
Very nice .. may i know your instagram page ?? For contact ?
simpleexcelvba.com/about-me/
or directly:
tomasz@simpleexcelvba.com
no instagram yet :)
Thanks. I received an error message at the "Set session = Connection.Children(0)" the message was "The enumerator of the collection cannot find an element with the specified index." Is it possible to fix it? SAP opens but is not possible to log in.
Thanks again!
Have You tried other indexes like 1 or 2? Have You checked the name of connection - any typo?
@@SimpleExcelVBA I already check Typo, I tried other Index, but there's no login yet.
Unfortunatly the Rec and Play Script option is dissable, si I was trying to running from Excel VBA
@@Oscarxxxification Oh, so this is the reason of error. Are You able to turn it on or is it the corp settings?
@@SimpleExcelVBA That's the corp settings
I tried to acces to RZ11 transaccion but I received a message, "there's no autorization"
However, in options in Script is able.
@@Oscarxxxification If You have no authorization for the specified transaction You can't access it manually or automatically using SAP scripting. But it is weird that You can't connect.
the black background is making me mad. It is unreadable on my work computer
Sorry. In that case remember, that You can find all the code in the article, link is in the description.