sap

  1. A

    Applications blocks Subroutine from continuing

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

    Control handle in SAP with VBA

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

    How to set date range in VBA coding to extract SAP reports

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

    Transferring data from Excel to SAP

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

    VBA and SAP

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

    Show SAP Status bar while SAP is executing through a script

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

    SAP / Excel Analysis

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

    VBA to check for PR SAP attachment

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

    Workbook won't open from SAP unless macro stops

    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 =...
  10. N

    SAP Script Yesterday's date

    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 =...
  11. C

    Automation of search and extract data from SAP (IM33)

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

    Automation of search and extract data from SAP (IM33)

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

    Convert SAP Date using VBA

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

    Excel VBA with JDA. Anyone know how or if possible?

    So I am trying to figure out if there is a way to script from excel to run a report and extract the results from JDA. I know with other programs like SAP you can use GUI Scripting but can’t find much on JDA. Any advice would be greatly appreciated.
  15. M

    SAP VBA (search text in SAP)

    Hi, I'm looking for a code where i can search for a word in SAP. I can't use setfocus because the word could be in another line for another itemnnumber in the loop. Does this ring a bell with anyone? Hope to hear from you soon and thank you in advance! Kind regards, Myrna
  16. R

    Auto logon to SAP to run excel macro

    Hello, i run a daily macro to generate some reports using the excel VBA and SAP macro as well. I made my macro to run early in the morning without me, but every time i get in my computer there is an error when the macro tries to connect to the SAP, "the enumerator of the collection cannot find...
  17. JackDanIce

    Excel connect to SAP with login

    Hi, I'm trying to create a spreadsheet for a client where a user providers there name and password to connect to and download data from SAP. First problem: I do not have SAP to test with, so can only do so when I teleconference with the client. Code I've tried to put together, with errors on...
  18. S

    Macros and SAP

    Hi there, I run a daily Profit & Loss statement each day. All of the data is found within a few different SAP transaction codes. I'm trying to build a macro that will go into each SAP report and retrieve the information that I need. I have a very good understanding of Excel and SAP; however, I...
  19. Z

    Date Entry of SAP through VBA

    Hi All, I have a macro which run automatically at a specific time which connect SAP and run the SAP script. The input of the starting date is expected to enter the current date deduct by 7 days. Below is the code which the starting date need to be specified a date. I am not able to use...
  20. C

    Close Spreadsheets after macro runs

    I am running a macro that goes into another application (SAP). In SAP it downloads data and exports it to an Excel file. by default when you export a file from SAP it automatically opens up (I don't want to change this default). But the spreadsheets don't open up until after the macro is done...

Some videos you may like

This Week's Hot Topics

Top