Excel VBA 内存溢出（错误 7）：需要更多的内存空间，或是遇到 64K 段边界限制。此错误有以下的原因和解决方法： Excel VBA-memory (Error 7): the need for more memory space, or encountered 64K segment boundary limit. This error has the following causes and solutions:1、打开了太多的、文档或资源文件。关闭不需要的应用程序、文档或资源文件。1, opened too many, document, or resource files. Close unnecessary applications, documents or files.2、模块或过程太大了。将庞大的模块或过程分成几个。虽然这样不能节省内存空间，但可避免 64K 段边界限制。2, module, or the process too. The large module or process into several. Although this does not save memory space, but can be avoided 64K segment boundary limit.3、在 Microsoft Windows 标准模式下执行。按增强方式重新启动 Microsoft Windows 。3, the Microsoft Windows standard mode. By enhancing restart Microsoft Windows.4、在 Microsoft Windows 增强方式下执行，但超出了虚拟内存的空间。空出一些磁盘空间以增加虚拟内存，或至少确保有空馀的空间。4, on Microsoft Windows enhanced mode execution, but beyond the virtual memory space. Some empty disk space to increase virtual memory, or at least ensure that the remaining free space.5、一些驻留程序在运行。减少一些驻留程序。5, some of the resident program is running. Reducing the number of resident programs.6、设备驱动程序装载的太多。减少一些不需要的设备驱动程序。6, device drivers loaded too much. Reducing the number of unnecessary device drivers.7、Public 变量超出了空间。减少 Public 变量的数量。7, Public variables out of space. Reduce the number of Public variables. 不然你大概会一直好奇和不甘吧——家门前的那条小路，
