SAP VB script Translator to Excel Macro

By -

I developed GPT models for converting SAP VB scripts into Excel Macros, but the outcomes were inconsistent, varying with each attempt. Exhausted from trying to achieve consistency, I opted to develop a web-based solution for translating SAP VB scripts into Excel Macros, instead of using my GPT models. Kindly give the web solution a try and adhere to the instructions provided on the website:

SAP VB script Translator to Excel Macro

  1. Before clicking the 'Translate to Macro' button, ensure you have selected the start and end lines of the SAP VB script that needs to be looped in the Excel Macro for processing multiple data sets.
  2. Copy the translated macro from this website and paste it into an module in VB Editor.
  3. Transfer the field layout and sample data from this website to the first sheet of your Excel file for processing multiple data sets.
  4. Make sure to log into SAP before executing the Excel Macro.



For support & inquiry, please contact bryan.ohjs@gmail.com.
- SAP R/3 Implementation for 25 years in SD, LE, MM, Retail / Fashion, WM, QM and PP - SAP project manager and OCM lead - Certified in SAP R/3 SD, FI/CO, Workbench (ABAP Development), CRM – Online store & Internet sales - Business Process Re-engineering (BPR) - 7 SAP SRM and 3 CRM (Supplier & Customer Relationship Management) implementation - Industry Experience: Pharmaceutical, Diagnostics, Retail, Fashion, Electronic, Electric, Petro-Chemical, Mill, Shipbuilding, Automotive - SAP Industry Solution: IS-Retail, IS-AFS, IS-MILL

Comments

Post a Comment

Popular posts from this blog

How to automate how to process mass transaction without ABAP code (SAP ABAP coding 하지 않고 엑셀 매크로 VBA로 SAP 생산오더 만들기)

By -
Image
'For English Readers' SAP 프로젝트를 하다보면 개발자의 도움없이 특정 Tranaction을 대량으로 자동으로 실행시킬 경우가 있다. 물론 ABAP coding 을 배워서 하든지 ABAP개발자가 개발 하면 가능하다. 대량 Data를 엑셀로 정리하여 개발된 프로그램으로 실행하면 된다. 만약 상황이 여의치 않고, 본인이  엑셀 매크(VBA)를 조금 해본 경험이 있다면 아래 VBA source code 를 복사하여 엑셀로 개발하면 가능하다. 아래 SAP 생산오더 생성 및 변경을 위한 엑셀 매크로 VBA를 참조하시기 바랍니다.    물론 생산오더 포함하여 SAP recording 이 가능한 모든 Transaction 에 대해 적용 가능하다. 다른 Transaction 을 실행하고 싶다면 SAP script recording를 실행하면 자동으로 VB source가 recording 되므로 크게 걱정할 필요는 없습니다. Recording 된 VBA source 파일(*.vbs)을 열어 "session.findById" 시작하는 문장을 엑셀로 복사하여 수정하면 된다. 그러면 Scirpt Recording 시작해보자.  1. 아래 화면을 참조하여 Script Recording 기능을 활성화 해주어야 한다.           1.1. 먼저 t-code RZ11을 실행합니다.                  1.2. 매개변수 이름에 sapgui/user_scripting을 입력한 후 Display 버튼을 누른다.               1.3. "Change Value"을 누른다.           1.4. 새 값 상자에서 TRUE를 선택합니다. 그런 다음 저장 버튼을 클릭합니다.           하단 오른쪽 모서리에 있는 이발소 모양 아이콘은 GUI 스크립팅이 활성화되었음을 보여준다. 2. SAP GUI에서 스크립팅을 활성화하려면     2.1  SAP 사용자 정의를 클릭한 다음 옵션을 클릭합니다.    
Read more »

Material Label as a industry standard on traceability along the whole supply chain.

By -
Image
The automotive industry places increasing demands on traceability along the whole supply chain. To ensure this traceability, material flow and information flow from suppliers to customers have to be aligned. This can be achieved by a unique material label on the smallest package unit containing a clearly defined set of traceability information. Up to now, there is no common industry standard for such a label. The MAT-Label is a complement to existing labels such as VDA 4902, Odette and GTL. These existing logistics labels are taken into account and referenced. If you happen to scan a material label to decode, and change content to generate new 2D matrix barcode for testing, please try this How to decode barcode of Material Label   Please find simple decode function of text in 2D barcode below: Please find data identifers in mat-label below: For support & inquiry, please contact bryan.ohjs@gmail.com.
Read more »

How to execute Transaction with mass data without ABAP coding using SAP Script Recording, 코딩없이 대량 데이타를 SAP 업로드 할 수 있나요?

By -
Image
In the realm of SAP, there exists a menu that holds significant value for both SAP users and consultants. Allow me to acquaint you with this menu, a gateway to executing transactions involving substantial data volumes, all without the need for intricate ABAP coding. Intrigued? Imagine a scenario where you effortlessly transfer vast data sets from Excel to SAP transactions, all facilitated by a bit of VBA coding. This menu, known as "Script Recording and Playback" in SAP, is the key to this endeavor. To embark on this journey, simply copy the provided source code and paste it into the Visual Basic Editor. You can access this editor by launching Excel and pressing ALT+F11. The possibilities that unfold are truly captivating. Absolutely, I'm here to help you through the process. Let's break it down step by step: 1. Review the SAP VBS File: First, let's thoroughly review the SAP VBS file I've provided below which will help you understand its content and identify
Read more »