Error message: Microsoft Visual Basic for Applications Unexpected error (35010)
MS VBA error when uploading from Excel
Users will unexpectedly see the above Microsoft Visual Basic for Applications error when attempting to upload from the EBM Office Bridge ribbon in Excel. Usually occurs as soon as a user clicks Upload and is often related to virtual or application memory. Closing the VBA host and reopening can effect a resolution.
- Close and reopen Excel entirely.
- Repair document / worksheet / workbook.
Adjust virtual memory: In control panel, go to system > Advanced system settings > Advanced tab > Performance settings > advance > change Virtual memory. Then select custom size and increase it to a reasonable amount of value. Initial size 8000, Maximum Size 15000. Click ok and restart the computer to make the change. And the problem goes away.
The explanation is that when VBA is compiling, the virtual memory gets filled up quickly when you are compiling a big project.
- Test on another user profile within the same machine. If it works, the issue is with your user profile and you'll need assistance from your local IT team.
- If it does not work on another user profile on your machine, test on another machine. If it works, then the issue is with your machine and you'll need assistance from your local IT team. Usually a complete uninstall/reinstall of Excel can correct.
Also, it sometimes helps to recompile the VBA code (if there is one):
ALT+F11 to open the VBA-Editor.
Choose menu: Debug > Compile to recompile forms and code.