Hey, thank you for the help. I have a question. I have a SAP Hierarchy view and can't find rows. How to get data from such type of Hierarchical tables using VBA ?
Thank you so much, it is very helpful for me.But when I run the code to fetch data from SAP,I find a problem.If the table.RowCount>110,I can not get the values of the cells.It return empty.So I can not fetch all the data from SAP to Excel.I have try to serach the problem by Google,but I do not get useful infomation.Could you help me to resolve this problem.Thank you a lot.
Hi thank you so much for your help! It's really nice that I see that many more people into excel & Sap collaboration. May I ask which references do you use? My excel doesn't read the table as an object, I actually get errors and straggling to pull up details from the tables.
Hello! I did not use any special reference, Office and Excel reference should be enough to work. Could You tell me more about the error? The description and number and the line?
Awesome stuff! Question for you, when adding to my watch window, I don’t have the ColumnOrder displayed. I have a Columns option, where I can expand and ultimately find Columns.Count property as well as a Columns.Item(row #goes here).Title I can’t seem to get the nested for loop part to work though. Specifically, the getcellvalue line. I added the SAP GUI scripting API reference already, so it should work, but it’s saying the object doesn’t support this properly or method. When I hover my cursor over the colOrd_arr(j), it displays the correct value for j Any thoughts? Looking forward to part 2! Love your SAP scripting videos
Is that the case from the second part? simpleexcelvba.com/how-to-deal-with-sap-tables-part-2/ Already working on video, I will upload as soon as I finish this :)
Thanks for this great tutorial it was really helpful! However I have two question regarding tables; 1. Is there any option running script not via excel interface but from playback option in SAP? In general, I use excel file just for the data to be transferred to sap not for login sessions etc..then coding part becomes really easier 2.Is it possible to run loops to check and fill a value if the cell in sap is not correct? It will check every row and specific cell and then if it does not match the value stored in excel file then it will paste that value from excel to SAP. Again thanks a lot for hardwork!
1. Yes, it is possible due to Script Playback :) 2. Of course, everything what is possible in VB/VBA You can do in case of SAP. SAP is just an object in your code :)
Thank you for you work! Its really help me a lot :з Btw do you know is it possible to make an Excel macro which will be automatic updates data from the SAP table from time-to-time (for example once a week \ day) Or we need to open Excel-file and run macro manually anyway? (Or perhaps we can use other languages script to RUN Excel macro which will RUN SAP and updates the data :D ?)
You can create macro in Excel VBA, create a script in VBS where You open Excel / launch the Excel VBA macro and that VBS script schedule in Windows Task Scheduler :)
Great video!! It really helped me.
Happy to hear that :)
Hey, thank you for the help. I have a question. I have a SAP Hierarchy view and can't find rows. How to get data from such type of Hierarchical tables using VBA ?
Hi, thanks! I'd love to see the recorded script, reach me private or comment the article with the code please :)
Thank you so much, it is very helpful for me.But when I run the code to fetch data from SAP,I find a problem.If the table.RowCount>110,I can not get the values of the cells.It return empty.So I can not fetch all the data from SAP to Excel.I have try to serach the problem by Google,but I do not get useful infomation.Could you help me to resolve this problem.Thank you a lot.
Hi, You need to scroll this table to see & get the data. See my other video: th-cam.com/video/CfLvAc_6Gs0/w-d-xo.html
Hi thank you so much for your help! It's really nice that I see that many more people into excel & Sap collaboration. May I ask which references do you use? My excel doesn't read the table as an object, I actually get errors and straggling to pull up details from the tables.
Hello! I did not use any special reference, Office and Excel reference should be enough to work. Could You tell me more about the error? The description and number and the line?
Awesome stuff! Question for you, when adding to my watch window, I don’t have the ColumnOrder displayed. I have a Columns option, where I can expand and ultimately find Columns.Count property as well as a Columns.Item(row #goes here).Title
I can’t seem to get the nested for loop part to work though. Specifically, the getcellvalue line. I added the SAP GUI scripting API reference already, so it should work, but it’s saying the object doesn’t support this properly or method. When I hover my cursor over the colOrd_arr(j), it displays the correct value for j
Any thoughts? Looking forward to part 2! Love your SAP scripting videos
Is that the case from the second part? simpleexcelvba.com/how-to-deal-with-sap-tables-part-2/
Already working on video, I will upload as soon as I finish this :)
Looking forward to seeing it :)
Thanks for this great tutorial it was really helpful! However I have two question regarding tables;
1. Is there any option running script not via excel interface but from playback option in SAP? In general, I use excel file just for the data to be transferred to sap not for login sessions etc..then coding part becomes really easier
2.Is it possible to run loops to check and fill a value if the cell in sap is not correct? It will check every row and specific cell and then if it does not match the value stored in excel file then it will paste that value from excel to SAP.
Again thanks a lot for hardwork!
1. Yes, it is possible due to Script Playback :)
2. Of course, everything what is possible in VB/VBA You can do in case of SAP. SAP is just an object in your code :)
@@SimpleExcelVBA Thanks again!
Thank you for you work! Its really help me a lot :з
Btw do you know is it possible to make an Excel macro which will be automatic updates data from the SAP table from time-to-time (for example once a week \ day)
Or we need to open Excel-file and run macro manually anyway? (Or perhaps we can use other languages script to RUN Excel macro which will RUN SAP and updates the data :D ?)
You can create macro in Excel VBA, create a script in VBS where You open Excel / launch the Excel VBA macro and that VBS script schedule in Windows Task Scheduler :)
@@SimpleExcelVBA
Thanks a lot again!
Yeah, it seems to be the best decision