VBA Script
- or -
Post a project like this1599
£100(approx. $125)
- Posted:
- Proposals: 3
- Remote
- #2607252
- Awarded
Description
Experience Level: Entry
We have a VBA routine the picks-up data files for conversion into formats required for upload into an ERP system. The code runs fine if the VBA application has already been run, but when the function is initialised before having run any code, it errors out and I am unable to work out why this is. At present, I simply put a stop somewhere in the code. When the code stops at this line, I then run the rest of the routine and it processes without any further errors. Clearly, this is not appropriate for lay users wo want to simply open the workbook and process the data file as and when required without having to put a stop in the code to overcome this error.
I am advertsing this as a fixed price job for someone to work out how to ensure the VBA application is in a state that allows the code to run without error immediately on opening of the workbook I use for processing these files.
I have come across a similar error on files we use for scraping web data and have overcome this by looping to check the readystate of the website before proceeding but are unable to identify the cause of the issue when running this particular tool and expect there is an issue with initialisation of VBA application.
The workbook requires some initial setup with respect to file locations where the upload template and data files are saved and I will provide the tool, sample data file and upload template on approval of this job. Screenshots of the configuration required for the workbook are provided below.
I am advertsing this as a fixed price job for someone to work out how to ensure the VBA application is in a state that allows the code to run without error immediately on opening of the workbook I use for processing these files.
I have come across a similar error on files we use for scraping web data and have overcome this by looping to check the readystate of the website before proceeding but are unable to identify the cause of the issue when running this particular tool and expect there is an issue with initialisation of VBA application.
The workbook requires some initial setup with respect to file locations where the upload template and data files are saved and I will provide the tool, sample data file and upload template on approval of this job. Screenshots of the configuration required for the workbook are provided below.
Stewart A.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
11 Nov 2019
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