Lukket

Excel Macro/Visual Basic 6.0 Expert Needed

See attached document.

Open this in Excel. In the developer tab you can run the macro and see the code.

This macros is is meant to convert a flat sheet of data( Creditors ) into an importable batch of invoices. The macros is supposed to stop when the last line of data is reached on the creditors sheet but it does NOT STOP. it loops indefinitely.

The macros does actually need to loop to identify every new invoice each time there is a change in the order number/supplier invoice number and then loop as many times as necessary to complete the correct number of lines so long as the line above its order number is exactly the same .

I need someone to fix the infinite looping while still allowing it to look to identify every new invoice each time there is a change in the order number/supplier invoice number and then loop as many times as necessary to complete the correct number of lines so long as the line above its order number is exactly the same .

So basically fix it, without breaking whet currently works.

Evner: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: voorbeeld excel macro visual basic scripts, copy multiple columns excel macro visual basic, excel macro visual basic unicode, excel, microsoft excel, excel macro visual basic download combine multiple files tabdelimited single column files, excel macro visual basic help needed urgent, looking for visual basic 6 0, looking for visual basic 6.0, necesito programador visual basic 6.0, programador visual basic 6.0 freelance, programming in visual basic 6.0, programming microsoft visual basic 6.0, visual basic 6 0, visual basic 6.0, visual basic 6.0 coding, visual basic 6.0 online programming, visual basic 6.0 programming, visual basic 6.0 xml sunat freelance, busco programador visual basic 6.0

Om arbejdsgiveren:
( 27 bedømmelser ) Durban North, South Africa

Projekt ID: #17557926

32 freelancere byder i gennemsnit $25 på dette job

mrbrave

HI, In addition to your requirements, I can also speed up the process. I am Excel VBA expert with over 7 years of experience. I have completed over 150 Excel VBA relared projects here. I am available now to st Flere

$25 USD på 1 dag
(256 bedømmelser)
6.7
avinav606lx

Hi I can do this quickly Ping me to discuss more Thanks A

$25 USD in 3 dage
(172 bedømmelser)
6.5
rostovsoft

I can develop VBA application of any complexity. I have more than 10 years of professional software development. I’ve successfully finished large VBA application https://www.freelancer.com/projects/php/excel-vba-mac Flere

$28 USD in 10 dage
(112 bedømmelser)
6.3
johncarteratfl

Hi.. I am a Microsoft certified excel professional who is well versed with maccro programming. Let me know what you are trying to achieve here. I ahve gone though the excel and ran the macro and yes, I see that it runs Flere

$25 USD in 10 dage
(46 bedømmelser)
5.7
archanaoswal

I have gone through the code and can fix it within an hour. I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis mat Flere

$25 USD på 1 dag
(83 bedømmelser)
5.8
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Ok. Let me do. Willing to take up your project. Thank you, Regards.

$25 USD på 1 dag
(60 bedømmelser)
5.6
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I think you should get LastLine then use it for loop. I have used this logic in many programs. Flere

$25 USD på 1 dag
(68 bedømmelser)
5.3
prabakarm23

Greetings for the Day!!! I have 8 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 Serv Flere

$30 USD in 3 dage
(65 bedømmelser)
5.1
aubrey03

I am an Excel VBA specialist. I believe the problem in this macro is the proper setting of loop counter. I know the solution to this kind of issue so it is best if you will award this project to me.

$25 USD på 1 dag
(34 bedømmelser)
5.0
serdaryalcin

Hi, Here is my offer. I have completed several similar projects at the past. I can complete it in 24 hours. Best Regards, Serdar Yalcin

$20 USD in 10 dage
(21 bedømmelser)
4.4
Ahmed818

Hello, sir it as very easy job i can finish within 1 hour it will be my first time t work with employer from south africa , i will do my best waiting your answer Thank you

$20 USD in 0 dage
(41 bedømmelser)
4.5
Mfaisalshahzad00

Hi, I got its fix. Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be Flere

$25 USD på 1 dag
(18 bedømmelser)
3.9
$23 USD in 10 dage
(6 bedømmelser)
3.2
paulodayto08

Hi, Good Day! I can help you to complete this project. I know how to do this, Feel free to message me anytime to discuss this project. I am a VBA Macro developer and has strong knowledge in MS Excel formulas and f Flere

$20 USD på 1 dag
(4 bedømmelser)
2.5
matheusbsl

Hello! Just try this code before the last "Loop" line: R = R + 1 If it works fine, please award me! Thanks

$20 USD in 0 dage
(1 bedømmelse)
2.2
dangphap

Hello, Your macro use a loop without the base-line aka the scenario to tell the code when to stop so it will run for infinity. I can modify you macro at the reasonable price. Please pm me for further discussion. Flere

$20 USD in 2 dage
(6 bedømmelser)
2.3
kishu0079

Hello, I can do this project for you. I have completed this type of project recently. So , It will be easy for me to complete this task. I have more than 5 years of experience in Data analytics field. If you are in Flere

$30 USD på 1 dag
(3 bedømmelser)
2.1
$25 USD in 2 dage
(1 bedømmelse)
1.5
$25 USD på 1 dag
(2 bedømmelser)
1.0
$20 USD in 2 dage
(0 bedømmelser)
0.0