sap

I've created a macro that opens SAP, and downloads a number of different reports. It was working fine last week, but after an update to Windows 7 from xp (and excel 2007 to 2010), I now receive the following error during a loop in my code: Run-time error '619' The control could not be found by...

Hello, I have noticed that SAP has an option where we can record a macro similiar to the way MS excel allows you to record macros, and then saves this as a .vbs file. Im wondering if there is any way to write some code in excel vba, to fetch data from SAP and/or emulate user interaction with...

I am new to SAP and I have found a lot of good articles but I cannot setup the SAP object in Excel 2010. Within the editor I selected Tools then References and searched for anything that says SAP and I cannot find it. The code that keeps failing is: Set oBapiCtrl =...

Hi i am using SAP at work and can post a basic journal using FB50 but need want to upload a journal i have in excel can someone show me the steps to upload. do i need a template for the jnl please help

I would like to create a macro to take a column of UPC numbers in a list in column A and look them up in SAP and return the material number our company uses. Many clients remit using the UPC number, but the Material number seems to be more useful on our end. I picture this as a template that a...

I would like to create a macro to take a column of UPC numbers in a list in column A and look them up in SAP and return the material number our company uses. Many clients remit using the UPC number, but the Material number seems to be more useful on our end. I picture this as a template that a...

I'm trying to write a macro to automate certain functions for our users. Essentially, the users would enter numbers (relating to clients) in column B and e-mail adresses in column D on a worksheet. A set of Bex reports would run based on the first number entered, then the workbook would be...

Hi, I have a sheet that gets loaded into SAP through the GLSU add-on and the numbers must be 2-decimal places and must be numbers but for example, Excel takes 168.90 and cuts off the zero to 168.9. Changing the number format just changes the display, not the actual number. I've searched for...