sap

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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 =...
  8. 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 =...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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
  14. 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...
  15. J

    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...
  16. 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...
  17. 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...
  18. 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...
  19. B

    Check in SAP if Excel Cell is existing

    Hello everyone, im working on a macro to check if from my EXCEL file, the reference in C3 is existing in SAP module ZP14. the information needed are the "reference of the article" Col.C and the "supplier ID" Col.A in the Excel book and the "family of the article" Col.B (TOF or NTF) Is there...
  20. S

    Calculating rate with variable payments.

    Hi, I currently use the RATE() function in Excel to calculates rates before entering details in SAP. However this only works if the payments are the same every month, which is not always the case. Here are two common examples I would like to be able to calculate: Variables: 60 months £50,000 pv...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top