sap

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.

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

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

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

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

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

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

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

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

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, I am trying to write a VBA code from excel to populate fields within SAP program. I can get all of them to work except for the field titled Reqmt No. I have attached the code below and a screen dump of the SAP fields...can anyone she some light/help please? Sub UpdatePO() Dim...

Hi Guys Need your assistance in creating a formula For eg : the txt as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information Want to get the word after "Returned CI" i.e in this case it is SAP Want another formula to get the string after...

Hi Guys Need your assistance in separating the words given in the subject line For eg : the subject line as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information I want to separate word which comes after Returned CI till ":" or "-". In this...

Hi All, can some one please help me on my below requirement. - I recorded a script in SAP - now i want to give that script in excel so that clicking in excel SAP script should get run in back end save the excel file in specified folder. - *in sap coding there are two paths given which needs...

Guys im having trouble getting the value from an SAP field into my excel Column. I need to get the following value to copy into cell C5. I cant get SAP To copy the value or insert it into cell c5. all help appreciated. Set sapguiauto = GetObject("SAPGUI") Set app =...

Hello. I created VBA code to download data from SAP and it works fine. The only thing is that it takes a long time and changes SAP screens frequently. Is there any possibility to force SAP window to stay in the background? Macro starts a new SAP session at the beginning and closes it at the...

Hello, I have excel macro which should open and log in into my SAP but appaer the error message "Run-time error 438 Object doesn't support this property or method" Here is the code which I am using Sub Vendors_to_IC_statement() Dim pword As String pword = InputBox("Please enter your...

Hi everyone, I'm needing help with my code when SAP tables return no results. Currently it works when there is data but if there's no data is just stops without finishing. I have no idea how to fix this. I've read some posts saying I need to add an On Error Resume code but not sure how to do...

Hi all, i have a workbook containing 2 worksheets. One is called "Transmittal" and the other is called "SAP". The transmittal worksheet is basically a template form that employees use to enter debits and credits. The SAP worksheet is basically a summary or a simple list of the same debits and...

Hello, I'm having some issue's getting my code to return the status bar value from VA41 in SAP as the contract is completed. The status bar will be the contract number entered so it is crucial that I get this in. I've posted my code below but all my attempts have failed so I left off the code I...