Find Jobs
Hire Freelancers

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

$30-250 CAD

已关闭
已发布超过 6 年前

$30-250 CAD

货到付款
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.
项目 ID: 14793437

关于此项目

10提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
10 freelancers are bidding on average $255 CAD for this job
用户头像
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 experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $250 CAD - payment after work completion
$250 CAD 在3天之内
4.9 (86条评论)
6.5
6.5
用户头像
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 develop much projects with Excel VBA. I major in C#,ASP.NET(MVC),PHP(Laravel & Yii Frame work, OpenCart), Web scrapping,web scrapy, Python(Django), HTML5, Javascript and Jqeury. I can offer you my projects before. Then you can trust me and check mine. Please let us contact and make a good friendship. Thanks.
$155 CAD 在3天之内
5.0 (20条评论)
5.3
5.3
用户头像
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 在3天之内
5.0 (25条评论)
5.4
5.4
用户头像
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 - m
$250 CAD 在3天之内
5.0 (30条评论)
5.0
5.0
用户头像
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 在3天之内
5.0 (18条评论)
5.0
5.0
用户头像
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 are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$277 CAD 在5天之内
4.8 (39条评论)
5.2
5.2
用户头像
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 I ensure you that I can complete your project with good quality. We can discuss more about this project in chat Looking forward to work with you on this project. Thank you
$30 CAD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 two. First code is communication with ERP system and second is executing rest of required operations. Ive tried with timeout but it was quite unstable and I couldnt rely on it as sometime entire DB was loaded and sometime not. Restructuring and dividing code helped in my problem and if I would know more about your code I could help you with yours. I see that you understand logic that is happening behind execution of code so I could give you few advices and you could do it by your own, free of charge. I would just have to know more about process and steps you perform. Regards,
$217 CAD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

CANADA的国旗
Canada
5.0
3
付款方式已验证
会员自11月 20, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。