Excel Macro/Visual Basic 6.0 Expert Needed

$20-25 USD

Closed

Posted

over 5 years ago

$20-25 USD

Paid on delivery

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.

Data Processing

Excel

Software Architecture

Visual Basic

Visual Basic for Apps

Project ID: 17557926

About the project

31 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

31 freelancers are bidding on average $25 USD for this 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 start and will provide you output within 30-60 minutes. Thanks

$25 USD in 1 day

4.9

(297 reviews)

6.9

@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 in 1 day

5.0

(127 reviews)

6.5

@avinav606lx

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

$25 USD in 3 days

4.9

(178 reviews)

6.5

@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 in 1 day

4.9

(155 reviews)

6.3

@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 matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana

$25 USD in 1 day

4.9

(103 reviews)

6.1

@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 on a infinite loop. But if you can explain a little more in detail what you want to achieve, I can help you. Thanks.

$25 USD in 10 days

5.0

(57 reviews)

6.1

@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. So, I can fix this issue. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra

$25 USD in 1 day

4.8

(95 reviews)

5.7

@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 day

4.9

(99 reviews)

5.2

@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 Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)

$30 USD in 3 days

5.0

(65 reviews)

5.1

@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 functionality. I am also a PMO Analyst and my primary task is to generate and analyze a Financial Reports. You can check my reviews to help you decide. Thank you

$20 USD in 1 day

4.9

(43 reviews)

4.7

@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 days

5.0

(21 reviews)

4.4

@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 another 100% satisfied client. I am regularly doing following kind of tasks: Open this in Excel. In the developer tab you can run the macro and see the code. Thanks.

$25 USD in 1 day

5.0

(18 reviews)

4.0

@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 interested, Please contact me ,So I can finish it as soon as possible. Waiting for your response. Thanks in advance.

$30 USD in 1 day

4.9

(5 reviews)

3.8

@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. Thank you!

$20 USD in 2 days

5.0

(8 reviews)

2.6

@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 day

5.0

(2 reviews)

2.3

@mcuizon256

Hi Have a nice day I have a B.S. of Elementary Education Generalist, ICT Teacher. I am a very analytical person that loves a challenge in any area. I tend to see problems as opportunities to expand my mind and spirit. thanks and god bless

$27 USD in 10 days

0.0

(0 reviews)

0.0

@nebyam

I have vast experience in Microsoft Excel application and am ready & available to work on this project perfectly, thanks

$25 USD in 2 days

0.0

(0 reviews)

0.0

@klbr9

You need to chance the order of the counter (R = R + 1) from the if statement at the end of your code. Move it to a row before the LAST counter (LCOUNT = LCOUNT + 1), which is outside the if block the counter (R = R + 1) is at the moment . In other words, just move the counter (R = R + 1) on the if statement one level above.

$27 USD in 1 day