Check vba code is robust for excel versions
- or -
Post a project like this1053
£50(approx. $63)
- Posted:
- Proposals: 17
- Remote
- #3275649
- Completed
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
1792694164249214494331264463516719
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