sap

How can I solve the following problem? I use SAP to extract reports into Excel spreadsheets. I save this file on my computer, and every time it's saved, it opens the file. I no longer want it to open the saved files from SAP. How can I make this setting?

Does someone have experience with loading data from an SAP Analysis Excel file into PowerApps? I would like to load the data from such a file into Microsoft PowerApps and create an app with it. However I get the following error: I think it's due to the SAP formating of the Excel sheet. I tried...

Hi All, I am working on my SAP automation process. I have written most of it but I am struggling with writing code for copying dates from two different rows to Posting date : "from" and "to". LastRow = sht.Range("D2").CurrentRegion.Rows.Count sht.Range("D2").Copy...

Hello all expertise, Hope you are doing well! I have a macro that able to run on my local machine but it doesnt work when i run it on the another machine (server). It shows me the Run Time error 5. When it does when I click on the button in excel is that it will access to SAP system, saves...

TO : ALL EXPERTS I have the VBA problem and stuck over half year. Because my knowledge in VBA is almost nothing. The question is Running a recorded macro (VBA in SAP) for SAP, I found VBA stop in saving the export file as Excel file. Problem : Recorder can't record any action in SaveAs dailog...

Hi, my company has customer portal that allows customer to place order that comes in as text file. I'll download the text file saved in my c drives. Then I will go to Sap customized tcode to enter the sold to, ship to, sales org and upload the text file to create sales order. Each text file has...

I'm making a list of the many Excel integrations with other softwares, like SAP, Salesforce etc. Thank you! :)

I want to automatize the following procedure: I want to attach an email after sending it to a document in SAP, but as soon as the "select Files:" windows appear my code is blocked from continuing bc this window belongs not to the SAP application itself (I don't know if these are the correct...

In our SAP system, we have a mass attack tool. There is one point at which my VBA cannot control the SAPgui anymore, it's when the "Select Files:" window appears (see screenshot). Yesterday I got a solution on how to find this window from a good man here in the Forum. The macro gave me all the...

I'm a newbie to excel VBA coding. I used script recording but I'm not sure how to setup date range from current date to 2 months intervals to extract report from SAP. Kindly assist - Thanks! Dim SapGuiAuto As Variant Dim SAPApp As Variant Dim SAPCon As Variant Dim session As Variant...

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...

Hi all, Although i only recently joined as a member, this forum has been invaluable and often popped up when searching the internet for solutions to problems i have had in the past. Thankyou to the community for all your hard work. I have been working on macro's now between excel and SAP for...

Hello, I wrote a macro to automate the extraction of data from SAP using SAP GUI scripts. What I want to achieve now is to add a status bar in a form which shows the actual text on the SAP status bar while the report is being produced. I know how to read the SAP status bar, but I just can't...

Hello, I'm using the Analysis tab to pull things from SAP BI - for whatever reason if it goes over a certain number of records, it either disconnects me from SAP Business Objects, or gives me a "no data" message. What I'm trying to do: I'm trying to pull all orders for all accounts, so I can...

Sub teste() Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine Set SAPConnection = SAPApplication.Children(0) Set session = SAPConnection.Children(0) session.findById("wnd[0]").maximize...

Hello!! I am really having trouble with this issue here. This is my code: Sub sap_attachment_2() 'anexos na lista de anexos Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine Set SAPConnection = SAPApplication.Children(0) Set session =...

Hello, I am trying to run an report daily and save to a specific location. Here is the code, how do I command to say "every time I run the script to look at yesterday's date" If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application =...

I would like to create an excel macro where I can click on a button, and it will perform the following functions: 1. Open SAP Easy Access 2. Open IM33 - Display Budget of Inv.Prog.Position 3. Search terms laid out within specific cells 4. Upon displaying results, copy information displayed 5...

I would like to create an excel macro where I can click on a button, and it will perform the following functions: 1. Open SAP 2. Open IM33 - Display Budget of Inv.Prog.Position 3. Search terms laid out within specific cells 4. Upon displaying results, copy information displayed 5. Paste into a...

When I export my sap reports into excel (use TAB deliminator) to change the date format from 12.03.2019 to 12/03/2019 I use the function =VALUE(SUBSTITUTE(W191,".","/")) and then format it to required format. I want to be able to use VBA to save time The number of columns varies for different...