Đã Đóng

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.

Kĩ năng: Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 27 nhận xét ) Durban North, South Africa

ID dự án: #17557926

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

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 Thêm

$25 USD trong 1 ngày
(256 Nhận xét)
6.7
avinav606lx

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

$25 USD trong 3 ngày
(172 Nhận xét)
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 Thêm

$28 USD trong 10 ngày
(112 Nhận xét)
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 Thêm

$25 USD trong 10 ngày
(46 Nhận xét)
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 Thêm

$25 USD trong 1 ngày
(83 Nhận xét)
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 trong 1 ngày
(60 Nhận xét)
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. Thêm

$25 USD trong 1 ngày
(68 Nhận xét)
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 Thêm

$30 USD trong 3 ngày
(65 Nhận xét)
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 trong 1 ngày
(34 Nhận xét)
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 trong 10 ngày
(21 Nhận xét)
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 trong 0 ngày
(41 Nhận xét)
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 Thêm

$25 USD trong 1 ngày
(18 Nhận xét)
3.9
$23 USD trong 10 ngày
(6 Nhận xét)
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 Thêm

$20 USD trong 1 ngày
(4 Nhận xét)
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 trong 0 ngày
(1 Nhận xét)
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. Thêm

$20 USD trong 2 ngày
(6 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(3 Nhận xét)
2.1
$25 USD trong 2 ngày
(1 Nhận xét)
1.5
$25 USD trong 1 ngày
(2 Nhận xét)
1.0
$20 USD trong 2 ngày
(0 Nhận xét)
0.0