sap gui

Hi I have the code below that is not working. I have two problems, it runs for the first row of my file then the message box pops up and then it stops and then if I run again, it restarts from the top and it replaces the numbers on column E with new numbers. 1) How do I get the macro to...

Greetings Excel Experts, I have a problem with some materials with leading zeroes that Excel automatically trims on exporting from SAP. For example, 000100-0113 exports as 100-0113. However, when I query the trimmed value in SAP, the material is not found, and it generates and 619 runtime...

Hi........I try to automate the SAP theme setting by using Excel VBA. My requirement is “If Selected theme not equal to " Corbu Theme" then change the selected theme to " Corbu” This is the code to load the SAP GUI Options >>>Shell "C:\Program Files...

Hello, I'm facing problem when try to copy data from excel. As it is a large data in column "A" I need to use the clipboard option in transaction FBL3N. Unfortunately it does not work. I know that Copy Past in SAP does not work. However I do not know how to insert values (existing in Excel) to...

OK, I'm starting to think this can't be accomplished. I have an SAP screen that contains approximately 7 lines of data. Each line has text labeling a specific type of transporation (Ground, Standard Overnight, Express, etc.). Unfortunately, these aren't always in the exact same order. I need...

Hi everyone i need to built a VBA code to extract data from the sap and add those data into the excel file. I need to extract data based on the product number, Can anyone help me out how to do that. Thanks in advance

Hello there, We've been running this VBA Macro for a while then it suddenly stopped working. I tried to specify the 'session.StartTransaction' window again, but it still doesn't work as it runs into 'Error 619: Control could not be found by ID. Here's the script: The debug stops at this line...

Hi all, I'm retrieving data from the SAP Erp system using a main macro that calls several macros, using a structure like this: sub Main() call Macro1 'get parameters from the Excel worksheet call Macro2 'input some basic parameters in SAP call Macro3 'get first data from a SAP transaction...

Hi All, I have a problem that im struggling to find a solution for online but i feel like it should be possible, so im hoping you guys can help me!! So my situation is... that through VBA i need to save an already open PDF to a file-path of my choosing where the name of the open PDF file will...