ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vba Memory (https://www.excelbanter.com/excel-discussion-misc-queries/40693-vba-memory.html)

billy2willy

Vba Memory
 

I am trying to run a macro and it says Microsoft Visual Basic Out of
Memory. Can I reset or clear the memory somehow?


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=396246


StinkeyPete

There is a problem with your VB code if you are getting that error message.

"billy2willy" wrote:


I am trying to run a macro and it says Microsoft Visual Basic Out of
Memory. Can I reset or clear the memory somehow?


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=396246



Dave Peterson

Are you opening a text file and parsing the fields?

If yes...

"Out of Memory" Message Using the OpenText Method
http://support.microsoft.com/default...;EN-US;q134826



billy2willy wrote:

I am trying to run a macro and it says Microsoft Visual Basic Out of
Memory. Can I reset or clear the memory somehow?

--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=396246


--

Dave Peterson


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com