VBA script for SAP Client - code fix or optimization help

I have some Code I wrote in Microsoft Visual Basic for Applications (VBA) within an Excel Spreadsheet.

The Code interfaces with SAP 740 in the same capacity that a .VBS file would if you Recorded it with SAP's in-built recorder.

The difference is that I've expanded upon it, adding dynamic data inputs and I then post-process the results further within Excel and generate reports.

Essentially, my code is simply performing automated motions that somebody could click on their own if they wanted to spend the time doing it. I'm saving time by automating those clicks and inputs and post-processing and report generation.

The code is working well. My problem is that SAP Client will sometime "hang" or "freeze" after a while, usually on Code which is running multiple actions sequentially. Or multiple reports back to back.

I have to then "End Task" of the SAP Logon and the SAP Active Windows in order for Excel to "unfreeze" and then it shows me the typical error message and the END or DEBUG buttons we are familiar with.

I then hit END, and then re-launch my SAP Client, and start my VBA Code over again. I hope it doesn't crash the next time. Often it doesn't. Sometimes it does again.

My request with this project is to have you provide guidance or Optimize my VBA Code so that it no longer crashes SAP.

Alternatively, to Code a way to force close SAP if it detects that its frozen and re-launch it automatically.

This will require some back-and-forth and perhaps will take multiple days or weeks to accomplish because I cannot provide you access to my company's server and so you will not be able to test anything in real time.

All you will be able to do is Chat/Email with me and I can show you my Excel File and then I can apply your recommended fixes, test it later on my own, and get back to you with the results.

I can record videos of what is happening and share them. But absolutely no proprietary or confidential information will be shared so your access and insight into the specifics will be limited.

I am mostly looking for somebody who knows already after reading this far, exactly how to fix my issue and can simply pass along that knowledge. I am proficient with VBA scripting, at an Intermediate level I would say. 100% self taught however.

Thank you!

Keahlian: SAP, Perancangan Perangkat Lunak, Visual Basic, Visual Basic untuk Aplikasi

Lihat lebih lanjut: quickbooks vba code client records, fix liquid help css code firefox, optimization function code vba, zip code shipping script, verification code website script, code generation script, motorola subsidy code client, fix bad php code, token code channel script, php code repeat script, poker flash client script, invitation code php script, help center live script, php code client management system

Tentang Pemberi kerja:
( 3 ulasan ) Canada

ID Proyek: #13780965

Diberikan kepada:


I have done a number of SAP VBA interfaces with huge success, with debugging error code checking

$155 CAD dalam 5 hari
(0 Ulasan)

10 freelancer menawar dengan rata-rata $222 untuk pekerjaan ini


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lebih banyak

$300 CAD dalam 3 hari
(58 Ulasan)

Hi, this looks like something we could help you with. Our team is Russian-Canadian. We specialise in: PHP & PHP frameworks, WordPress & Woocommerce, Opencart, Magento, API development, HTML5, CSS, JavaScript, Bootstrap Lebih banyak

$185 CAD dalam 1 hari
(12 Ulasan)

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lebih banyak

$277 CAD dalam 3 hari
(34 Ulasan)
$250 CAD dalam 7 hari
(8 Ulasan)

Hi. I am an expert in fixing errors. I can fix errors for all softwares as you request. I can start right now

$200 CAD dalam 3 hari
(7 Ulasan)

A proposal has not yet been provided

$150 CAD dalam 7 hari
(1 Ulasan)
$233 CAD dalam 3 hari
(1 Ulasan)

Dear client I am highly interested to do this project. I will make you happy.I don’t need any upfront or milestone payment. Pay me when you will happy. Looking forward. Thanks

$155 CAD dalam 3 hari
(0 Ulasan)

Hi! I Have VBA Experience doing Forms interfaces, Data extraction on Web Apps and user tasks automation. I need to confess I haven't did a SAP automation, but I suppose you use WScript Sheel, Windows Handle or some Lebih banyak

$250 CAD dalam 10 hari
(0 Ulasan)

Hi, Do you know if what is taking ime is the return from SAP or processing the data returned from SAP ? What function modules are been called from your VBA ? I do have access to SAP systems so i can test your VBA Lebih banyak

$222 CAD dalam 5 hari
(0 Ulasan)