When using a VBA tool written by a colleague in Excle, an error is reported as soon as it is run:
user defined type not defined
The error statement checked is:
Dim newFile As MSXML2 DOMDocument
My environment is windows10 + office2016, so I guess he used Microsoft XML V3.0, and I’m using V6.0.
The solution I found online is as follows: If in Tools> References: Microsoft XML V6.0 was selected. When declaring variables, use the following format:
Dim newFile As MSXML2 DOMDocument60
user defined type not defined
The error statement checked is:
Dim newFile As MSXML2 DOMDocument
My environment is windows10 + office2016, so I guess he used Microsoft XML V3.0, and I’m using V6.0.
The solution I found online is as follows: If in Tools> References: Microsoft XML V6.0 was selected. When declaring variables, use the following format:
Dim newFile As MSXML2 DOMDocument60
Read More:
- When C language refers to a user-defined type as a parameter, an error segmentation fault is reported
- User defined height of layeui carousel
- Matlab realization of user-defined curve and legend
- [How to Fix] NameError: name ‘requests‘ is not defined & NameError: name ‘request‘ is not defined
- User defined profile in vscode settings.json And default configuration defaultSettings.json
- Applet error – referenceerror: regeneratorruntime is not defined
- Error reported using layui $is not defined
- JS error: require is not defined
- Uncaught ReferenceError: FileAsyncWriter is not defined
- pyspark : NameError: name ‘spark’ is not defined
- [NLP] NameError in using nltk: name ‘freqdist’ is not defined
- Uniapp ESLint error: ‘uni‘ is not defined no-undef [How to Solve]
- Error in v-on handler: “ReferenceError: XXX is not defined“
- Eslint error handling: ‘QQ’ is not defined
- Reference error: ecarts is not defined
- Vue project, browser error: referenceerror: H is not defined
- Vscode cannot write user settings. Open user settings, clear errors or warnings, and then type again
- python multiprocessing.pool NameError: name is not defined
- Solving the problem of NameError: name ‘reload’ is not defined
- Django project running service reported an error NameError: name ‘OS’ is not defined