Joel Ting
Joel Ting
  • 22
  • 854 992
Extract and Transform SAP Data with ONE click! Automation with Excel VBA and Power Query
📚 Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!
joelting.com/sap-ebook/
Are you spending hours manually extracting, transforming, and analyzing data? What if you could automate the entire process with just one click? In this video, I’ll show you how to combine SAP GUI Scripting and Power Query to create a seamless workflow for automating data extraction, transformation, and analysis.
You'll learn:
✅ How to extract data from SAP using GUI Scripting
✅ Transforming raw data in Power Query with essential techniques
✅ Automating file path updates with Power Query Parameters
✅ Integrating everything with Excel VBA for a fully automated process
By the end of this tutorial, you’ll understand how to combine SAP GUI Scripts with Power Query to streamline your workflow, save time, and focus on delivering insights rather than managing data.
#SAPScripting #SAPGUIScripting #SAPAutomation #excelvba #PowerQuery #ExcelTips #DataAutomation #ProductivityHacks
DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.
MY FAVOURITE TOOLS & GEAR:
📝 Notion - How I Manage My Day - affiliate.notion.so/hpemzmxen3jq
MY OTHER SOCIALS:
🌍 My website / blog - joelting.com/
🐦 Twitter - JoelTing92
🏢 Linkedin - www.linkedin.com/in/joel-ting/
🙎🏻‍♂️ WHO AM I:
I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation and productivity.
📧 GET IN TOUCH:
If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.
P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links 😜
มุมมอง: 4 074

วีดีโอ

Save 10 HOURS with this Data Automation Project - SAP to Power BI
มุมมอง 7K5 หลายเดือนก่อน
Book a call with me: 👉 joelting.com/book-a-call/ 📧 Join my FREE newsletter to access all resources used in this video: 👉 joelting.com/newsletter-download/ 0:00 Introduction & Overview of automation components 2:59 Python scripts and modules 3:29 SAP GUI automation with Python 5:15 SAP AFO workbook refresh automation with Python 7:31 Loading refreshed data into Database with Python 09:05 Power B...
Automate SCREENSHOT Capture with Excel VBA & SAP Script
มุมมอง 3.8K6 หลายเดือนก่อน
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ Ever wanted to automatically capture and crop screenshots for your SAP automation? This video is your ultimate guide! Learn how to: ✅ Trigger screenshots using VBA ✅ Paste screenshots into Excel w...
One Click to Bring Your Financial Data into SQL Database
มุมมอง 3.6K11 หลายเดือนก่อน
💡 SQL Databases are powerful for data analysis, and in the world of Finance, we handle massive amounts of data, often scattered across various platforms. The time wasted searching for data and switching to ERP systems can be frustrating. Join me as I reveal how I revolutionized data storage and management in my department by replacing traditional Excel spreadsheets with a high-performance SQLit...
I created 20 vendors in SAP with a SINGLE click with Excel VBA!
มุมมอง 13Kปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ 📚 RESOURCES IN THIS VIDEO: Vendor Creation Automation: drive.google.com/file/d/1ye0G7Y0A3jLKalpQCXo1Q16z-6z2jvXI/view?usp=drive_link Automate the creation of vendors using SAP Scripting and Excel ...
Automate Bulk PDF Extraction with Excel VBA and SAP GUI Scripting
มุมมอง 10Kปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ 📚 RESOURCES IN THIS VIDEO: PDF Export Automation: drive.google.com/file/d/1OUXryTp_i11HP8_S2p0CHwvryq3niHtU/view?usp=drive_link Automate the extraction of sales order PDFs using SAP Scripting and ...
SAP GUI Script Development Tool That Will BLOW YOUR MIND
มุมมอง 15Kปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ In this video, I will show you how to use Scripting Tracker to streamline your SAP scripting process. The Scripting Tracker is a powerful tool that helps SAP script developers to easily identify a...
Excel VS SQL as Database - My view as a Financial Controller
มุมมอง 14Kปีที่แล้ว
In this video, I'm sharing my thoughts on using Excel and SQL as a database for financial analysis and management. As a Financial Controller, I've had extensive experience with both Excel and SQL and have seen the pros and cons of each approach. I'll be discussing the benefits and limitations of using Excel as a database, including its ease of use, flexibility, and powerful data analysis tools....
Automate SAP Spreadsheets Export with Python and Analysis with Pandas in a single Python script
มุมมอง 41K2 ปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook 📚 RESOURCES IN THIS VIDEO: Python Script Template: drive.google.com/drive/folders/1NVKLHKHRPfsdRJ7kTMV4Sg5qM9yxtxze?usp=sharing Anaconda Download Link: www.anaconda.com/ Most of us analyst understa...
Compare Multiple Forecast in a Single Visual with Power BI
มุมมอง 6K2 ปีที่แล้ว
I frequently need to compare different versions of forecast. What is our original budget, what is our previous month estimates, what is our target and so on. In this video, I will show you how I manage to analyze and present different forecast and estimates together to see what are the changes between them and validate whether the current forecast is prepared correctly with Power BI. with Power...
Export multiple SAP reports with For Loop in Excel VBA - SAP GUI Scripting
มุมมอง 35K2 ปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ In this video, I will share how you can export multiple SAP reports with different parameters using for loop in Excel VBA. Timestamps 00:00 Overview 00:21 Script Recording in SAP GUI 01:27 Develop...
Splitting data into multiple tabs with VBA - Interacting with Exported Excel Spreadsheet from SAP
มุมมอง 14K2 ปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ In this video, I will share how you can interact with the Excel spreadsheet exported from SAP and apply some steps to format and edit the spreadsheet based on your likings. All these can be done w...
Copy Excel Ranges and Paste into SAP Multiple Selection | SAP Scripts with Excel VBA
มุมมอง 46K3 ปีที่แล้ว
Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! joelting.com/sap-ebook/ I have always been tasked to run SAP report based on certain criteria/values that was usually sent to me via email in the form of Excel. In this video, I'll share my way of automating the process ...
Dynamic Variance Analysis with Power BI - Different Forecast Versions Comparison
มุมมอง 24K3 ปีที่แล้ว
When I was first started my journey with Power BI, I always struggled to create visualization for showing the variances between different budget/forecast versions. Things are always done manually in Excel as I'm only able to total up the different versions and manually substract them in a spreadsheet. I'm able to find videos and tutorials about actuals comparing against budget and previous year...
Resolving Common Issues for SAP GUI Scripting | SAP Settings and Debugging Tips for SAP Scripts
มุมมอง 54K3 ปีที่แล้ว
Resolving Common Issues for SAP GUI Scripting | SAP Settings and Debugging Tips for SAP Scripts
Automate SAP Data Extraction with Excel VBA & SAP GUI Scripting - Minimal Coding Required
มุมมอง 300K3 ปีที่แล้ว
Automate SAP Data Extraction with Excel VBA & SAP GUI Scripting - Minimal Coding Required
Using Excel Data (Filtered) As SAP Multiple Selection Criteria with Power Automate Desktop
มุมมอง 25K3 ปีที่แล้ว
Using Excel Data (Filtered) As SAP Multiple Selection Criteria with Power Automate Desktop
SAP Logon and Handling Password with Power Automate | Step-by-Step Guide using Azure Key Vault
มุมมอง 20K3 ปีที่แล้ว
SAP Logon and Handling Password with Power Automate | Step-by-Step Guide using Azure Key Vault
Automate SAP data extraction to Excel with Power Automate Desktop - No Coding Required.
มุมมอง 208K4 ปีที่แล้ว
Automate SAP data extraction to Excel with Power Automate Desktop - No Coding Required.
Automate Microsoft Teams Members Lists Generation with Power Automate. No Coding Required.
มุมมอง 7K4 ปีที่แล้ว
Automate Microsoft Teams Members Lists Generation with Power Automate. No Coding Required.
Joel Ting | An Introduction about Tech Tips for Accounting
มุมมอง 4.4K4 ปีที่แล้ว
Joel Ting | An Introduction about Tech Tips for Accounting

ความคิดเห็น

  • @ChanChingYi
    @ChanChingYi วันที่ผ่านมา

    May I ask that where can I find the full version of this short?

  • @dionliaw1347
    @dionliaw1347 10 วันที่ผ่านมา

    Hi Joel, Can we modify the macro so that it directly pastes the SAP data into the existing workbook, instead of creating a new workbook after it runs?

    • @JoelTing
      @JoelTing 10 วันที่ผ่านมา

      Hello! Yes, it's possible. One option is to read the newly exported Excel file, copy the data, and paste it into your current workbook. Alternatively, I prefer exporting the data as a text file. You can then read the text file and paste the data into your workbook. This way would avoid the exported Excel from opening automatically at the end of the process (which happens when you are exporting data in excel format).

    • @dionliaw1347
      @dionliaw1347 10 วันที่ผ่านมา

      @ thank you so much for your reply. But instead of needing to copy and paste the exported data to my workbook, is there anyway that the SAP data can directly exported into my workbook?

    • @JoelTing
      @JoelTing 10 วันที่ผ่านมา

      Yes, you can, but it's important to understand the specific SAP elements you're working with. Different elements require different methods for data extraction. Simple field values are relatively easy to retrieve. However, if you're dealing with tables, the approach varies depending on the table type and how it needs to be accessed. But, yes, it's possible.

  • @ketatgenhorst
    @ketatgenhorst 15 วันที่ผ่านมา

    I am using a report that someone automated years ago at work. I opened the module and saw the "placeholders" and googled them along with SAP Scripting. Glad Google sent me here. Thank you for your help.

  • @BillBoyification
    @BillBoyification 17 วันที่ผ่านมา

    Thank you very much, this video is useful for me.

  • @MrBond986
    @MrBond986 17 วันที่ผ่านมา

    Great video 👍👍👍

  • @bathinimallikarjuna7128
    @bathinimallikarjuna7128 21 วันที่ผ่านมา

    Container showing <No Varibles> Please help

    • @JoelTing
      @JoelTing 10 วันที่ผ่านมา

      Hello. Probably we'll need to know, which container and which line is it that the error occurs in.

  • @bettadays1
    @bettadays1 22 วันที่ผ่านมา

    The thing with SQL vs Excel though is the coding part. It’s difficult especially for someone who doesn’t know how to code

  • @dcdien07
    @dcdien07 28 วันที่ผ่านมา

    Please give me python code file, i want to learn argparse to specify argument when run python file like your video

    • @JoelTing
      @JoelTing 27 วันที่ผ่านมา

      Hello. You can register with your email here and download the whole package used in this video. joelting.com/newsletter-download/

  • @jpemanahan8699
    @jpemanahan8699 28 วันที่ผ่านมา

    I was so happy when I found this video since I deal with a lot of data extraction in SAP, but later felt sad because the "Script Recording and Playback" features of our SAP were disabled :(

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      Hello. I recommend reaching out to your IT department. They often have specific policies regarding automation. When it comes to automating data inputs, they tend to be quite cautious. However, if you're only extracting data, they're usually more open to providing scripting access. Some companies create a separate SAP ID specifically for automation purposes, restricting it transactions that provides read-only access to users.

  • @godnevercheats3880
    @godnevercheats3880 28 วันที่ผ่านมา

    I'm using SAP ECC. Can you please help me with copying the text just a word/number from the saved message(it'll always appear in the left below side) that comes when you save or make any changes using a tcode.. I want to copy it and then paste it in excel.

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      Hello. Are you referring to getting the text in the status bar? You can access text in status bar using session.findById("wnd[0]/sbar/pane[0]").Text

    • @godnevercheats3880
      @godnevercheats3880 28 วันที่ผ่านมา

      @@JoelTing No, I'm refering to the dialogue box that will appear when I create/change a document. For eg: lets say I'm using VA01 T code or vf01 or any other creation or modify t code and when I'm done making changes in the document using VA01 T code, I'll save it and it will generate a Document number which will trigger a 606183 has been created or saved in the bottom left corner which you can double tap and it'll open a window(called performance assistant) from which I want copy just the 606183 number.

    • @godnevercheats3880
      @godnevercheats3880 28 วันที่ผ่านมา

      and then paste it in a cell in excel

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      If you only need the number, you can identify the pattern in it, and get the number from the text. For example if the text in the status bar is "Document Number 606183 has been created", you can try the following: For i = 1 To Len(sbartext) If IsNumeric(Mid(sbartext, i, 1)) Then result = result & Mid(sbartext, i, 1) End If Next i ‘To paste value in Excel Range("A1").Value = result Assuming there's always only one number in the text, this will extract the numerical character only in the text. Then, you can paste in one of the cell in your Excel spreadsheet or use it later in your VBA script. This method works best when there's only one number in your text. If your text contains multiple numbers, you might need a different approach.

    • @godnevercheats3880
      @godnevercheats3880 26 วันที่ผ่านมา

      @@JoelTing it worked.. thank you for your help.. First I had to defined sapdocnumber =session.findByld("wnd[0]/sbar/pane[0]"session.findByld("wnd[0]/sbar/pane[0]").Text).Text then I used the if and end if provided by you.

  • @amarbabu7363
    @amarbabu7363 หลายเดือนก่อน

    Can you please share the code?

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      Hello. I have provided it in the description box. Feel free to download it.

  • @TheJaebeomPark
    @TheJaebeomPark หลายเดือนก่อน

    amazing!

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      Thanks, glad you liked it!

  • @Rroth140
    @Rroth140 หลายเดือนก่อน

    Do you have a video on how to write a GUI script that you can change the date and plan numbers daily

    • @JoelTing
      @JoelTing 28 วันที่ผ่านมา

      Apologies for the delayed response. Regarding your question, you can use Now() to retrieve the current date and time. Does this address what you're looking for? To design the approach, I would need to better understand your specific use case.

  • @lostfan5054
    @lostfan5054 หลายเดือนก่อน

    I am still not clear on why SQL would be better. You can do all these same functions with Excel, including Data validation and so on. The only thing i can see is that Excel can get laggy when you are dealing with huge data sets. Other than that, it seems like SQL is just another thing to learn.

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      While Excel can replicate many SQL functions, the real advantage of SQL lies in its performance and data management capabilities. When dealing with multiple table joins and complex queries, SQL executes these operations significantly faster than Power Query merges in Excel. If you are merging queries in Power Query, things will get slower and slower as you merge more tables in a single query. In SQL, you can create multiple views from the same from the same data, eliminating the need to duplicate data or maintain multiple files. Any changes to source data automatically reflect across all views, making data management more efficient. That being said, if the data is small and they can be processed efficiently using just Excel, I will always go back to Excel because SQL is not something that everyone would learn in the Finance community. Building the solutions in Excel are more easily transferable to others when someone else needs to take over the maintenance of the solutions.

  • @PhuongNguyen-cv1zk
    @PhuongNguyen-cv1zk หลายเดือนก่อน

    How to unable automatically open saved file when download from SAP GUI

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      @@PhuongNguyen-cv1zk hello. There does not seems to be a way to handle the opening of saved file well. One workaround is you could try exporting the output in txt file and use Power Query to convert it into an Excel table. I covered this in my latest video.

  • @BulentOner
    @BulentOner หลายเดือนก่อน

    But, many of the productive systems are not allowed scripting. Unfortunately

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Based on my experience, many companies are open to SAP GUI Scripting in production systems when there's a clear business need, especially for data extraction purposes. Typically, IT departments are willing to assist with such requests. They often provide scripting access to specific users or create dedicated robotic SAP IDs for this purpose.

  • @amitprasad5496
    @amitprasad5496 หลายเดือนก่อน

    Very valuable video, appreciate you sharing this. Question? Can this be done with SAP business ByDesign as well?

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      I'm not too familiar with SAP Business ByDesign. Is that web based? If it is, then SAP GUI Script will not work (SAP GUI Script only works for SAP GUI) but the general approach can still be applied using Power Query. For web-based systems, you can automate the extraction process using Selenium. Once you have the output file's path, you can replace it the parameter with the latest output file path, allowing the process to be automated in a similar manner.

  • @Sumanth1601
    @Sumanth1601 หลายเดือนก่อน

    Excellent content,.loved it 😊 I use power query for many of my workflows..but never managed to have it in conjunction with SAP, where can I find the copy of your vba script.. thanks again..

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! You can get the file for reference using the link below: www.dropbox.com/scl/fi/94a84nivqyeehtvv5fb7q/FAGLL03Extract.xlsb?rlkey=d8mlg4mrc62kbwrjuxy1x0gkn&st=onekagzv&dl=0

  • @davidnatera8923
    @davidnatera8923 หลายเดือนก่อน

    Excelente video, con este metodo te evitas tener que escribir más lineas de codigo VBA

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Yes, and it's much easier to maintain since not all users are familiar with VBA, while Power Query is quite user-friendly for everyday Excel users. I've worked on several projects and successfully handed over their maintenance to the team with little VBA knowledge.

  • @PauloDoutel
    @PauloDoutel หลายเดือนก่อน

    Dear Sir, Thank you so much for sharing your extraordinary knowledge, which has been of great help to all of us. I would like to know if you could provide a practical example of how to upload preventive maintenance operations (010, 020,030...) directly from Excel to SAP using the IA-01 transaction. The goal would be to create a task list, including all associated operations, as well as simple comments, more detailed ones, and preventive maintenance periodicities (PM01)such as monthly, semi-annual, annual, etc. If you have an example or guidance on this process, I would be very grateful. Best regards, Paulo Doutel

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! I'm not too familiar with the processes around IA01. Maybe you can book a call with me and I can give you some ideas on how this could be set up?

  • @assitantrevenueofficerjawa4052
    @assitantrevenueofficerjawa4052 หลายเดือนก่อน

    You are awesome I am your your big 🎉

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Thank you! :)

  • @GonaIbrahim-w7z
    @GonaIbrahim-w7z หลายเดือนก่อน

    Great job 👌👍👍👍

  • @saadazam1289
    @saadazam1289 หลายเดือนก่อน

    I need your help to pick up the data from vl03n in excel in different cells, can you please help me, i need data in excel via botton that i press the botton and data will com from SAP VL03N in excel in 4 required cells.

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! That can be done by just assigning the element text value to a cell value (for example: Cells(1,1).Value = session.findById(elementID).Text ). You just need to identify what the element ID in SAP, then assign it to a cell value in Excel

  • @MirzaAbdulRaheemBaig
    @MirzaAbdulRaheemBaig หลายเดือนก่อน

    hey i am encounter a problem in attach to running excel step. (i saved by document with export12345), copy paste the same in the Attach excel step. But getting this error (Make sure that no Excel file is currently being edited or blocked by a pop-up dialog. Also, make sure that the target Excel file has not been opened in Protected View.)- i dont have any other file opened, File alsways get open in editing mode(i dont have to press editing to make chnages) Please guide . Thanks in advance

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! Is it possible to output your table as a txt file instead? I found that using txt file would eliminate the complications of working with Excel file output.

  • @ivanarciniegas7324
    @ivanarciniegas7324 หลายเดือนก่อน

    thank you 😄

  • @chengyixie4761
    @chengyixie4761 หลายเดือนก่อน

    Hello everyone, may I know what is the element ID of VF03-PDF?

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! I'm not too sure what you are looking at. Do you have scripting tracker installed? You can try using that to check the ID.

  • @deepu03393
    @deepu03393 หลายเดือนก่อน

    Very nice and crisp liked it, can you please do a video on copy values from sap and paste on excel cells

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      Hello! That can be done by just assigning the element text value to a cell value (for example: Cells(1,1).Value = session.findById(elementID).Text )

    • @deepu03393
      @deepu03393 หลายเดือนก่อน

      @JoelTing Thank you so much!!

  • @tranbui6310
    @tranbui6310 2 หลายเดือนก่อน

    Hi Joel, I know I'm damn late but still want to ask you 2 questions: 1. I want to add multiple values for an input (plant --> 001, 002, 003). How can I customize it with coding? I tried For each for it only got the last value. 2. At the last step, I clicked "Generate" as I save the file for the first time. If running macro to refresh that file, VBA will tell me the file has existed. Do I need to run a side module to delete the current file before running it, or any solutions?

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello! 1. Try and debug step by step and see what's wrong in the loop. You should be able to pinpoint which part of your code goes wrong. I usually use For next loop and that has been working well for me. Alternatively, if you have multiple values, you can make use of the clipboard as well. Customize the clipboard with the input values, then in SAP use the paste from clipboard button. 2. Deleting the current file is one way to do it. Check if the file is already exist, if it is then delete it. Another alternative you can think about is to use the current time as part of the file name. Then, you would be sure that whenever you run the script, the file name is always unique.

  • @Fern1153
    @Fern1153 2 หลายเดือนก่อน

    Good work!! Thanks, you resolved my problem!

  • @williamrinversi5785
    @williamrinversi5785 2 หลายเดือนก่อน

    Hi Joel, when I display the BrowserHandle, the LocationURL is not visible. Any other way to get the URL?

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. So far, I am only able to get it work with LocationURL. Have you switched the Browser Control in SAP to Internet Explorer? When I use Edge as my Browser Control, then I am not able to locate the LocationURL.

  • @Riyaz313
    @Riyaz313 2 หลายเดือนก่อน

    Sir I automated the label printing by scriptting it in excel. When script run then it open word file which show how label will show and then script run further now my things is that how can this be automatically save in my desire folder

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello! I'm not entirely certain about your case. You should be able to interact with the word doc. From there, you should be able to save it just like your Excel file in VBA.

    • @Riyaz313
      @Riyaz313 หลายเดือนก่อน

      @JoelTing ya if I can do it manually I can save it I want it save automatically

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      @@Riyaz313 does the word document opens itself? does the word document have the same name for each script run?

    • @Riyaz313
      @Riyaz313 หลายเดือนก่อน

      @JoelTing yes it's open it's self and have different name every time. So I can have lists of labels in specific folder 📁 so I have record that how many label I have given

    • @JoelTing
      @JoelTing หลายเดือนก่อน

      @@Riyaz313 If you are familiar with VBA, you can try to get the word application using getobject method, then you would be able to connect to the word document and save it into your desired folder. You may need to establish a loop to keep the script waiting until your word document is loaded before connecting to it. That would be the approach I'll try. As I do not have a use case from my end, I cant be sure if it will work.

  • @MuphoShana
    @MuphoShana 2 หลายเดือนก่อน

    Liked it

  • @DesimetLatina
    @DesimetLatina 2 หลายเดือนก่อน

    i am going to learn sql as i have already knowledge of power bi and python. people are suggesting me to go for T-SQL. they are saying its more appropriate for financial analysis, should i go directly for T-Sql?or just sql or mysql. Thanks in advance

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello! I personally didn't use T-SQL before. From what I understand T-SQL, or Transact-SQL, is an extension of standard SQL designed specifically for Microsoft SQL Server. It adds extra features that aren’t available in standard SQL. While the basics of SQL are the same across different databases, T-SQL offers tools tailored to SQL Server. So, if you’re working with MySQL, for instance, you won’t have access to T-SQL features. So, I would say what you need to learn would really depends on what database that you are working with.

  • @dionliaw1347
    @dionliaw1347 2 หลายเดือนก่อน

    Hi Joel, If i am using citrix to access SAP, is there any other way can help? thank you

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. I do not have access to SAP via Citrix, so I'm not able to test if there's any workaround for it. Perhaps you could try to run the script in an Excel workbook within the Citrix environment to see if it works that way?

  • @ANUSHAYENGISETTY
    @ANUSHAYENGISETTY 2 หลายเดือนก่อน

    Hi, I am not able to record script in SAP GUI for vendor clearing using T-code F-44. Could you please help me

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. What is the difficulty that you are facing?

  • @albeehernandez7920
    @albeehernandez7920 2 หลายเดือนก่อน

    how can I get a Scripting Tracker?

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. You can check it listed in the description box of this video: th-cam.com/video/VBmbuSXRvIg/w-d-xo.html

  • @murattulek5783
    @murattulek5783 2 หลายเดือนก่อน

    You encouraged and inspired me man!

  • @mirasol2229
    @mirasol2229 3 หลายเดือนก่อน

    Hi Joel! Thank u for this! I have created multiple tools using this method of yours. Just a question tho, what if i need to copy 2 ranges for 2 different multiple selections. I tried declaring 2 lastrows and setting 2 ranges. However i dont know how to command the code to get range a for multiple selection 1 and range B for multiple selection 2. The code only copies range B to both multiple selection 1 and 2. Can you help me with this?

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. You can try only copying the range right before you click on the "Paste from Clipboard" button.

  • @mirasol2229
    @mirasol2229 3 หลายเดือนก่อน

    Hi Joel! Very very helpful video, can I ask how would I generate the texts in the status bar every after loop so I’d know what the status of my changes are? Appreciate your answer as this is my remaining problem for the tool im making 😊

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      Hello. Sorry for the late reply. Are you referring to getting the text in the status bar? You can access text in status bar using session.findById("wnd[0]/sbar/pane[0]").Text

    • @mirasol2229
      @mirasol2229 2 หลายเดือนก่อน

      @@JoelTing hi Joel! Thanks for this, will try it out 🙂

  • @assitantrevenueofficerjawa4052
    @assitantrevenueofficerjawa4052 3 หลายเดือนก่อน

    You are amazing Bhai

  • @jaypatidar5682
    @jaypatidar5682 3 หลายเดือนก่อน

    Hi, i am unable to find SAP GUI scripting API in reference, its also not available in the path you have shown. Any suggestions please...

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello. Are you using SAP via Citrix? Can you check via File Explorer if you have the folder "C:\Program Files (x86)\SAP\FrontEnd\SAPgui"?

  • @carlheroux777
    @carlheroux777 3 หลายเดือนก่อน

    Hi! This is an older video but I hope you see this. I use lot of scripts to automate extractions for users and usually, the next step after the extraction is to copy paste the data in the main workbook. When I put the copy paste code after the extraction code, it bugs because the macro seems to be going faster than the extraction opening and can't find the workook to copy from. I use 2 separate macros to solve that but is there any ways to have all the steps in the same macro? Thanks

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hi there. I had similar problems with you if the data export takes a long time. I'm able to solve this by exporting the table using List -> Export -> Local file -> Text with tabs instead. This process seems to be more consistent compare to exporting them in spreadsheet. Then, I'll pass the text file into a custom converts it into a table and saves it to Excel. Maybe you could try this approach and see if it works for you?

    • @carlheroux777
      @carlheroux777 3 หลายเดือนก่อน

      Hi! Thanks for you response! I will definitely give it a try! The size of my extraction are quite big indeed so that makes sens that Excel can't open the workook fast enough. Again, thank you the valuable informations you share! Its highly appreciated!

  • @wit4u
    @wit4u 3 หลายเดือนก่อน

    Hello Joel. I was using a similar code but "Set session = SAPCon.Children(0)" began failing some days ago (I guess due to some IT action on security topics). Checking with MsgBox(SAPCon.Children.Count) I get a zero as response... it looks like children are no more available. Also tried a different approach: "Set session = SAPCon.FindById("ses[0]")". Ever encountered a similar issue? Any suggestions to explore?

  • @iLona_IL
    @iLona_IL 3 หลายเดือนก่อน

    This is super brilliant presentation and very usefull for simple SAP user! Mr you are awesom! If you also could show how to extract several different reports and to save them into one work book, on different sheets. ❤

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      I'll try to work out some content on this. The general idea is once you have all the paths of the different reports after the export, you can just open them with VBA, then transfer them over into your current workbook. Another way to do it is via Power Query where you can setup data transformation steps and load it into your current workbook. We can use VBA to dynamically change the source into the newly extracted files.

  • @noviaic5418
    @noviaic5418 3 หลายเดือนก่อน

    Hi Joel, Thank you, your video is very helpful. I have a question if I may ask. So when I run the macro, and executing the data from SAP, a pop up in Ms Excel appear "Microsoft Excel is waiting to complete OLE action". I assume it happens due large data that I extracted in SAP during the process. Do you have any idea to avoid this pop up error? Thank you

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello! You can try adding Application.DisplayAlerts = False before you run your script and right before it ends, set Application.DisplayAlerts = True again so that Excel can work normally.

  • @GiulioEF
    @GiulioEF 3 หลายเดือนก่อน

    Hi, this video is amazing. However when I run the script in VBA, Run-time error '438' appears. Does anyone know what could be the problem? Thanks in advance

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello! Can you let me know which line triggers run-time error '438'?

    • @GiulioEF
      @GiulioEF 3 หลายเดือนก่อน

      @@JoelTing I didn’t expect you to answer, thanks so much! In the meanwhile I sorted the problem out. However now I have a new issue, i.e. I would like to input several data in SAP t-code (so instead of just one country code, for instance, I want to input 40). Do you know if it is possible? I have tried everything but nothing seems to work. So far I only managed to achieve this by doing a range.copy and then using sap script to paste 40 values in it. But it doesn’t seem the right way to me, even if it works

    • @GiulioEF
      @GiulioEF 3 หลายเดือนก่อน

      Also would you know which is the line of code needed to open SAP from scratch? I would like this macro to work even if the user does not have SAP already open

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      For multiple inputs, using range.copy and pasting from the Clipboard is the most efficient method. Alternative methods, such as scrolling and inputting values one by one, are more prone to errors due to potential variations in workspace size. Are you experiencing issues when pasting values, such as missing data?

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      To open SAP, the general idea is to run SAP using the following function: Function RunSAP(system As String, client As String, user As String, pw As String) Dim command As String command = "C:\Program Files (x86)\SAP\FrontEnd\SAPgui\sapshcut.exe -system=" & system & " -client=" & client & " -user=" & user & " -pw=" & pw & " -language=en" Shell command, vbNormalFocus End Function This requires the password of the user. Another thing to note is that this approach does not work for system that uses SSO. It's best to get SAP user ID that can log in with password and have access to SAP GUI Scripting. Once you run this function, you will need to run a loop to check whether the SAP window is opened before connecting to it.

  • @judebotecial8530
    @judebotecial8530 3 หลายเดือนก่อน

    Hi Joel thanks for the vid ive been automating a lot of functions with this. one problem i have now is when i have multiple tabs of SAP open that have different SID. sometimes i run it and it executes the actions in a different SID not for S4HANA. is there a way to specify which SID it runs on?

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello Jude. Yes, you can loop through all the system IDs available using objGUI.Children(i) to check the SID description before connecting to it. If you have multiple, and want to work with them individually by assigning each SID into individual objects.

  • @fadlyriza6314
    @fadlyriza6314 3 หลายเดือนก่อน

    hi Joel, why my sap shows this message 'Input must be in the format _,___,___,__~.___V'. i dont see any issues on your video showing any issues when data being transfer from excel to SAP. any idea to fix this? Anyhow, your video was very helpful & i followed step by step

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello. That seems to be a decimal place field? Could it be a maximum decimal place in SAP? As a first step, try to do it manually to see if it works. You just need to make sure the data you passed into SAP works in the first place. For example, if the SAP field only works with 2 decimal place, you must convert the value into 2 decimal place 1st in VBA before passing it into SAP.

    • @fadlyriza6314
      @fadlyriza6314 2 หลายเดือนก่อน

      The problem already solved by adjusting a little bit the script. Now I managed to run the script completely 1 cycle until the transaction is saved. unfortunately, it won't loop to proceed with other order nos. When i try to run it mentioned about couldn't found the ID? What could be the issue... Is it SAP settings or the script itself?

    • @JoelTing
      @JoelTing 2 หลายเดือนก่อน

      @@fadlyriza6314 That's most likely your session is not at the correct screen to input another order. That error shows that it is not able to find the field you specify to fill in the value. You can try putting in "/n" in front of your transaction (ie. /nMM03)to make sure it will always go to the main transaction page for you to perform your processes.

  • @deepakjayaram2351
    @deepakjayaram2351 3 หลายเดือนก่อน

    Hi, i tried to record a script for T-code YPSFDSD order data flow down under quality instructions but unable to move the workbooks from the field while script started recording.... could you please how to move and record

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      Hello! The T-code you mentioned there is not a standard T-code. I do not really understand what you meant by moving the workbook. The script recorder will only record interaction in SAP GUI. Once you are out of SAP, like using file explorer to save file, the recorder will not work. Depending on what you need to do, there's some workaround for it.

  • @Cuwubiq
    @Cuwubiq 3 หลายเดือนก่อน

    actually scripting tracker tool can help with the conversion part quite easily.

    • @JoelTing
      @JoelTing 3 หลายเดือนก่อน

      yea. Agree. If there's access to the scripting tracker, I would definitely use the tool to record in python instead of using the native recorder in SAP.