sap

Hi Team, I have written the below mentioned code. Problem - every time code is executed, its successfully login in SAP and show me the first screen for 1 second and then, its gets closed automatically. Can you please help Code:- Set app = CreateObject("Sapgui.ScriptingCtrl.1") Set Connection...

This is some recorded code from SAP to select a node within a VA03/CU51 transaction. If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(connection) Then Set connection = application.Children(0)...

Hello, I included a snippet of a code I use to automate invoice printing one by one, using invoices from Excel. I have problem to make an error handling code that will handle error #619. Basically, the way my sub work is that when an invoice is available, it will open a new window...

Mr. Excel, I truly appreciate all the great work you do! I have referenced your website for code many times, because your website is very well done, with excellent questions by people who knowledgeable in VBA I have come across a new issue that I am working through... We use Excel to organize...

Hi, I have a spreadsheet that contains several graphs. The graphs are from a fixed starting date to the current month. I want the graph to expand to the “current month” automatically. The data is coming from a separate tab within the workbook, but is automatically being updated from SAP BW, so...

Hi All, I've searched everywhere for an answer to this, but can't see that anyone has managed to solve this yet. My accounting software (SAP) runs a particular macro linked with excel, and as soon as this happens, the headers (A, B, C...) all get slightly cut off at the top of any open excel...

Hi, I'm not an excel expert but try to spend time to understand problems but this has stumped me. There have been a lot of changes in the environment that this file is used in so it could be a number of things, I'll explain a bit of background hoping to give an idea of what is wrong...

Hi All, I have a problem that im struggling to find a solution for online but i feel like it should be possible, so im hoping you guys can help me!! So my situation is... that through VBA i need to save an already open PDF to a file-path of my choosing where the name of the open PDF file will...

Is it possible to run macro code to do the following: Open up SAP Go to connections PR1 Go to SAP query vf03 (enter details in certain criteria fields) run the query export data to csv file I've looked online and can't find anything, but would be great help if running SAP through excel macro...

Right now I'm running an Excel script in SAP as this: Session.findbyid("wnd[0]/usr/tblSAPLSE16NSELFIELDS_TC/btnPUSH[4,6]").press Session.findbyid("wnd[1]/tbar[0]/btn[0]").press Application.Wait (Now + TimeValue("00:00:01"))...

I wrote a simple read-only SQL analysis on the SAP b1 database using adodb. However, I have to open an inputbox to enter the customer id and save this step. Would it be possible to connect it to the order acceptance window in sap and automatically update the excel spreadsheet when a new customer...

Hi, I have the following problem, I haven't yet figured out the possible solution. I have a report from SAP with a lot of customers, in columns there are credit control area, company code, customer number, name etc. and then financial values like Outstanding, Credit Limit etc. The issue is that...

I'm pulling data from SAP at work using VBA and SAP's built in Sript Recording and Playback tool. Within Excel there are many, many SAP reference libraries I just need the correct .dll so when I'm calling a SAP sripct command such as: session.findById("wnd[1]/usr/ctxtDY_PATH").Text as I get to...

I have a SAP Business Objects Web 7.5 Add-in in Excel 2007. The add in itself is made up of a compiled .xll file (CtExcelLinksWeb.xll) and a number of dll's. A bit of vba shows the xll is registered, and all of its registered functions. However, when I try to use one of these functions in VBA...

Hi, I'm using the following to make a connection between excel and SAP: If Not IsObject(SAPApplication) Then On Error GoTo SAP_NOT_OPEN: Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine End If er = Err.Number If Not IsObject(Connection) Then...

Hi guys, I am new to creating macro tools using excel VBA and SAP and I am studying on my own. I just want to ask if you can help me with creating my macro tool for clearing in SAP tcode f-03 because we are having backlogs of open items and this would help. Here is my recorded VBA from SAP...

Hello, New to SAP here and want to make a script to pull data. Never made an SAP script before I have LOTS of emails (50,000+ ) That contain PO #'s.In Outlook i created a VBA macro(With help from online as this was my first vba) to go through the selected emails of my choice and copy that PO...

Good afternoon, My first post on the famous Mr.Excel.com. Hope I would post a question that has been answered thousands times. I need to create a .VBS document/script from an excel sheet. Is there any easy way to do a "save-as" and choose the .VBS extension ? Once the .VBS is created, I...

Hi all, I'm relatively novice when it comes to Excel, however I do understand most concepts and by trial and error - and reading material - I've managed to create (again) relatively complex sheets when needed. Just to set expectations. So, to my particular case. The main purpose is to have a...

Currently the manual process exists where users access SAP and select query FS10N to produce a report. This report is then exported from SAP to .XLS format and saved to user's hard drive. I would like to automate this process with an Excel macro. So far I have implemented VBA code to connect to...