Đã Đóng

Need 2 advanced things in Excel VBA for SAP Scripting. Experts only please :)

Need 2 advanced things in Excel VBA for SAP Scripting. Experts only please :)

(1) Need to be able to set a configurable duration Timeout, when calling an SAP GUI scripting method with Excel VBA. Sometimes the Client freezes during SAP scripting events, and Excel is typically "locked" in an OLE call. The only way to unlock it is to End Task of all open SAP Sessions and then after that, also End Task of the SAP Logon window. Then Excel immediately unlocks and gives the standard End/Debug window. I need to automate this whole process with a Timeout so I can simply "start over fresh" when these freezes occur. They occur normally in 3 situations: (a) when pasting into SAP, (b) when exporting SAP to a spreadsheet, (c) when waiting for results of an Execute call.

The challenge is that during an OLE activity, Excel doesn't continue processing code. So it may have to be some type of external program or Library or something which is launched before the script call, that Windows OS can run and handle the timeout and end tasks if we dont sent a Kill command after SAP successfully executes the transaction. I am thinking that inserting this Timeout function in 3 specific "problem spots" in the code will suffice. Unless there is a way to unlock excel while waiting for SAP. I'm not sure it's possible.

I already have code written to handle the "start over" portion and resuming where I left off.

(2) Need to be able to logon to SAP from scratch. This means launching the SAP Logon file, then choosing a production environment from the list (top default one) and launching a session. This will be needed on initial launch of the script, as well as after the situation described in (1) above occurs. There will also be a window that pops up sometimes saying "you must choose to end current session, or start a second session". We need to detect and handle this window as well.

Kĩ năng: SAP, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: Vba,Sap scripting , Shapes\ n excel - 2, Shapes\ n excel -2 / for Angel521, sap crm experts, im good with excel i need an online job, excel macros need programmer, i have 300 names in excel file need to done copy from excel file into notepad file, excel $2-30, excel spreadsheets need built, excel sheets need filled, excel expert need simple solution, need advanced java, excel skills need vba, excel portal building advanced portals, php advanced search function

Về Bên Thuê:
( 3 nhận xét ) Canada

ID dự án: #14793437

10 freelancer đang chào giá trung bình $255 cho công việc này


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of Thêm

$250 CAD trong 3 ngày
(86 Nhận xét)

Hello sir. I 've read your post and so very interested in your job. I 'm sure I can satisfy you with my ability. I 'm working in part of coding and software developing for over 6 years. I have much experiences that Thêm

$155 CAD trong 3 ngày
(20 Nhận xét)

i have good exp in VBA as well SAP i can do this job Relevant Skills and Experience vba/3,sap/6 Proposed Milestones $611 CAD - Miesltone

$611 CAD trong 3 ngày
(25 Nhận xét)

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document Relevant Skills and Experience Excel VBA Proposed Milestones $250 CAD Thêm

$250 CAD trong 3 ngày
(30 Nhận xét)

Hi, i can help you with this project, please let me know more about it :) if you can share screen shots or teamviewer session will be perfect. .

$250 CAD trong 3 ngày
(18 Nhận xét)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. I am thinking of using Windows APIs and MSAA for automating this task. Below Thêm

$277 CAD trong 5 ngày
(39 Nhận xét)

Hi I've reviewed your complete project Details and I can strongly assure you that I will be able to provide you good quality of work. I have done lot of projects in this domain. You can check skills from my profile And Thêm

$30 CAD trong 5 ngày
(0 Nhận xét)

Hello, Guess I'm not bidding for project, but I would gladly spend my bid card to give advice... I had,(and still have similar problem in my company with ERP system communication), and I solve it by dividing code in Thêm

$217 CAD trong 3 ngày
(0 Nhận xét)
$255 CAD trong 5 ngày
(0 Nhận xét)
$250 CAD trong 7 ngày
(0 Nhận xét)