In its move to the open-source, cross-platform.NET Core, Microsoft will support Visual Basic in the upcoming.NET 5 and is expanding the programming language's supported application types to help VB developers migrate their code, but noted 'we do not plan to evolve Visual Basic as a language.' The expanded project types to foster a move to the. May 06, 2011 Run the Office setup again and choose the 'Customize' option (about 3rd dialogue window into the routine). Scroll down and look for the VBA option and select it (it should say install), make sure everything else is unticked (skipped). I think you'll find it works after that. Click to expand. In the code, make Excel save the workbook every now and then. I had to loop through a sheet with 360 000 lines and it choked badly. After every 10 000 I made the code save the workbook and now it works like a charm even on a 32-bit Excel. If you start Task Manager at the same time you can see the memory utilization go down drastically after.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
When you run a Microsoft Visual Basic for Applications (VBA) macro to programmatically exit Microsoft Excel, Excel appears to close as expected. However, an active Excel process continues to run.
This behavior may occur even when your VBA macro performs the following functions:
- Closes all open workbooks
- Calls the Quit method to exit Excel
- Sets the Excel object to 'nothing'
Cause
This behavior may occur if the following conditions are true:
- A COM add-in is installed in Excel.
- The COM add-in assigns an Excel or an Excel member reference to a global object.
Stop Running Program Visual Basic Excel Free
For example, this behavior is known to occur when the Google Desktop search tool is installed in Excel. For more information about the Google Desktop search tool, visit the following Google Web site:
Workaround
To work around this behavior, remove the COM add-in in Excel. To do this, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2007
- Click the Microsoft Office Button, and then click Excel Options.
- Click Add-Ins.
- Click Excel Add-ins in the Manage box, and then click Go.
- In the Add-Ins dialog box, click to clear the check box for the add-ins that are known to cause this behavior.
- Click OK.
Microsoft Office Excel 2003
- On the Tools menu, click Add-Ins.
- In the Add-Ins dialog box, click to clear the check box for the add-ins that are known to cause this behavior.
- Click OK.
More Information
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
Visual Basic
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.