Check vba code is robust for excel versions
- or -
Post a project like this1044
£50(approx. $62)
- Posted:
- Proposals: 18
- Remote
- #3275649
- Completed
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |
San Jose
19011434314165856778568298256664625623148534147752520143886740387349130599212656985
Description
Experience Level: Entry
I have 1 excel file with that uses vba to do the following:-
1) When you click on the button, it connects to an supplied excel sheet and fetches the data.
2) Checks that the supplied sheet is a valid sheet to use.
3) Resets the sheet using another button.
One of my users found an “error 91 – object variable with block variable not set”.
I need someone to look through the code and check if for robustness, and potential areas of failure such as different versions of excel and installed libraries and references.
There are approx. 250 lines of code
1) When you click on the button, it connects to an supplied excel sheet and fetches the data.
2) Checks that the supplied sheet is a valid sheet to use.
3) Resets the sheet using another button.
One of my users found an “error 91 – object variable with block variable not set”.
I need someone to look through the code and check if for robustness, and potential areas of failure such as different versions of excel and installed libraries and references.
There are approx. 250 lines of code
Andy P.
100% (16)Projects Completed
13
Freelancers worked with
11
Projects awarded
50%
Last project
11 Aug 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies