Find Jobs
Hire Freelancers

Edit Excel VBA program to incorporate a problem work-around

$30-250 USD

Completed
Posted about 10 years ago

$30-250 USD

Paid on delivery
I have an small existing Excel based program that was created entirely within Excel VBA. It accepts system time/date input upon pressing a “start” button and again for a “stop” button and then calculates the interval period and records it along with other data into an Access database file. Occasionally the system time freezes within the program for some reason and while the start time is always accurate, the stop time will always be the same as the start time and the elapsed time will show zero minutes because of the freeze. There is no consistency to the problem and I cannot reproduce the failure upon demand. I have, however, discovered a work-around that I would like to incorporate into the program to effectively fix this bug. The existing “stop” button stops and records the elapsed time and proceeds to a different page to allow additional input. Upon an instance when the time freezes, if I hit “stop”, go to that page, but then hit “back” the system time immediately adjusts itself and unfreezes. I can then immediately hit the “stop” button again and now my final entries will all be with the correct times. This seems to work even if I make this stop-back-stop sequence very quickly. I want someone to change the function of the “stop” button to incorporate this sequence into its function, if possible. The new “stop” button would function as it does now, except that within ½ second or so it would go “back” and within another ½ second or so return to the “stop” page to wait for the additional input as normal. Another consideration is that the existing code is password protected and the original programmer has forgotten what the password is. The included copyright material and license agreement clearly shows ownership in my name. It would be nice if the password were removed, but not absolutely necessary.
Project ID: 5811560

About the project

26 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
Hi John. This is Pravy. I do not want to demand the project for me as I lost that opportunity. However would stand in front of so many other bidders just with that extra qualification of being the architect of the program. This bid is just not let you promise anybody else to work on this bug, but not to loose myself the greatest reference anybody could get in this competative platform. On a side note, I am shifting my gear by gathering few more enthusiast freelancers and formed this brand new CodeCubers group and would love to work on our application to get a booster start. Last but not the least, i do not believe i have an opportunity to not let you award this bid to anybody else however you are going to be my favourite employer even if you do so :) Please accept my sincere apologies for letting you wait so long. I wish i could've more time than i had to work on the bug..
$55 USD in 3 days
5.0 (1 review)
1.7
1.7
26 freelancers are bidding on average $79 USD for this job
User Avatar
Dear, why we will have to incorporate this sequence of actions if we can directly fix the stop issu?? Can I have a look to this code? Thanks
$44 USD in 3 days
4.9 (277 reviews)
7.6
7.6
User Avatar
Hi, I'll be happy to try to help you with this code Please feel free to message me if you need to discuss any questions you might have prior to award
$100 USD in 1 day
4.9 (256 reviews)
7.7
7.7
User Avatar
Hi: I have clarification: When you say "existing “stop” button stops and records the elapsed time and proceeds to a different page to allow additional input", do you mean that it moves to a different sheet or you mean there's some kind of pop-up data entry form? Please connect with me to discuss more.
$35 USD in 1 day
4.9 (163 reviews)
7.0
7.0
User Avatar
Hi Jonathon. I can get it fixed for you in a day or 2. Its a very simple code to modify in VBA that would solve the start stop issue. Kindly share the sheet so I may have a look. Regards. Usman.
$110 USD in 2 days
5.0 (87 reviews)
7.0
7.0
User Avatar
Hello, First of all it is necessary to remove the password, otherwise the existing VBA code will not be accessible and modifiable. Is it an .xlsm or .xls file? Second: It seems to be a workaround, by speaking in strict software development terms, this is a tricky "solution", not a programming method. This kind of tricks may work or not, there is no any warranty on their function. On the other hand, this is strange enough, since Excel and VBA provide accurate timing functions. I have never had any problem with timers in VBA. Could it be possible to send me this file to check how it is implemented? A few words about me: I'm developing VBA programs for more than 15 years, and I'm a trainer for Excel and VBA for 12+ years. As you can guess, I have created a plethora of VBA programs of any kind and difficulty level, for both training purposes and business. Looking forward to hear from you, Kind regards, chriskerpini
$90 USD in 2 days
4.9 (75 reviews)
6.5
6.5
User Avatar
Hi, The calculation process must be too heavy for the excel. I am guessing there's a loop or even several nested loops in the process and the data to read might be too huge for the pc processor to calculate (running in a faster computer with higher grade of cpu specs might help, though it's not a solution). I need to see the file (either code protected or not it won't matter to me as I can crack it for you if you want). The best solution is to debug the problem and fix the code, as your idea to apply your workaround might work, but it's not the best way as sometime it just a matter of how the code is written. Let me know if you're interested to work this out with me. Cheers, Daniel
$50 USD in 3 days
5.0 (200 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.9 (123 reviews)
6.3
6.3
User Avatar
Hi I'm a 12 year experienced VBA developer... I will delivering high quality results to your project.... What version of excel was used originally for creating the file?? I nned this information in order to evaluate if it is possible or not to unlock your file.... Thanks for considering my proposal.
$79 USD in 3 days
5.0 (25 reviews)
5.5
5.5
User Avatar
Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. Looking forward to hear from you. We can start as soon as you award this project to me. Thanks Abhinov
$77 USD in 3 days
4.9 (59 reviews)
5.4
5.4
User Avatar
If you give me opportunity, I will help you with your project. Please check my profile and award me right away. With regards, Tom
$50 USD in 3 days
4.9 (34 reviews)
5.2
5.2
User Avatar
From your description of the problem, it seems that the now() function was used in a cell to store the time and it updates both start and stop time simultaneously. This results in a zero differential between start and stop. Instead of the workaround you suggested, I offer to fix the problem you are facing.
$55 USD in 3 days
4.8 (24 reviews)
4.9
4.9
User Avatar
Hello I am an Excel VBA developer. My bid is to unlock the VBA project, possibly fix the existing functionality and/or implement the workaround. Without seeing the workbook it's difficult to say how quick it will take, but I don't anticipate it will take longer than a day or two to deliver. Best regards, Brent
$70 USD in 3 days
5.0 (25 reviews)
4.3
4.3
User Avatar
I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, Web Designing and framework like CodeIgniter. my aim to deliver quality products to our customers within specified deadline. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs. PM to me for more discussion
$136 USD in 5 days
5.0 (6 reviews)
3.6
3.6
User Avatar
I might have a simpler solution for you. If your time stamps are based off of cell formulas (Like "=Now()", for example), then you could probably just insert a command to recalculate the workbook inside of the "stop" code. It should be a very easy add-in. You can test the solution yourself by hitting the "start" button and then, before you hit "stop", press F9 on your keyboard, which tells the workbook to calculate, and will refresh any timestamp formulas to the current time. I would guess that the reason you have inconsistent results is that sometimes you continue working in Excel, updating different cells, maybe even different workbooks, before you press "stop", and other times you press "start" and then leave it alone before pressing "stop". Again, you can quickly test this by trying it both ways. If you find these bring more consistent results, then feel free to contact me about incorporating the new piece of code. -David
$35 USD in 3 days
5.0 (2 reviews)
2.0
2.0
User Avatar
I have already completed several project involve VB and writing functions for Excel 2007 using VBA. Beside, I have experience with system programming using Window API to get the advance feature of system to perform these functions such as timing, events, ...
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked with VBA and Excel for many years and I am confident I can implement your requested changes with modest effort. You can also be assured that there will be no communication gap during the project. Thank you for your consideration.
$77 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$105 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Depending on the version of Excel we should be able to remove the password. Your issue is most likely related to how you are retrieving and calculating the time span. There are many ways to do so in VBA. It would be preferable to correct the timing routine rather than implement the change you suggested which could introduce other bugs. If you provide me with copies of the files I could be more definite regarding a solution.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A simple DoEvents before grabbing the timer should fix the problem. I would recommend this over your proposed solution. But if the code is password protected, how can we edit it? If we had the password to get into the vba, I could remove it, but if the vba is locked, this could be an issue.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lot of experience in working on excel and have used all the features. I have experience in all the other MS/Office products
$155 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Wilmington, United States
5.0
3
Payment method verified
Member since Oct 18, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.