Resolving Conflicting Excel VBA Macros
Budget: £20 – £250 GBP
I'm facing a problem in an Excel sheet where two of my VBA scripts are clashing. Specifically, the issue arises with macros that have been designed for automation.
I have a fast lookup function that loads data into a dictionary and functions as a fast lookup for the sheet, this works fine on it's own. I have another module that runs an API update this also works fine independently, but when both are running, the dictionary tries to reload/has errors reloading.
The ideal freelancer for this project should:
- Have extensive experience with Excel VBA programming and debugging.
- Be able to identify and resolve function conflicts effectively.
- Possess strong problem-solving skills to ensure the macros can run concurrently without issues.
Please provide examples of similar projects you have completed in your proposal.
I have a fast lookup function that loads data into a dictionary and functions as a fast lookup for the sheet, this works fine on it's own. I have another module that runs an API update this also works fine independently, but when both are running, the dictionary tries to reload/has errors reloading.
The ideal freelancer for this project should:
- Have extensive experience with Excel VBA programming and debugging.
- Be able to identify and resolve function conflicts effectively.
- Possess strong problem-solving skills to ensure the macros can run concurrently without issues.
Please provide examples of similar projects you have completed in your proposal.