Great idea Nathan.  Thank you for the suggestion.
 
Anna

________________________________

From: Encoded Archival Description List on behalf of Nathan Tallman
Sent: Mon 6/14/2010 3:01 PM
To: [log in to unmask]
Subject: Re: Visual Basic and "out of memory" error


Hi Anna, 

I can't say that I've experienced this exact problem before, but I have run into walls before when using Visual Basic for Applications within Excel and Access.  I was always able to find help in online forums.  Excel Help Forum <http://www.excelforum.com/> and Access Forums <http://www.accessforums.net <http://www.accessforums.net/> > were both helpful with programming challenges.  There are probably forums for straight Visual Basic (A google search just yielded several); I'd try posting a message on one of them.  The forum members are usually very experienced and willing to help.

Good luck,
Nathan Tallman


On Mon, Jun 14, 2010 at 4:45 PM, Quan Leon, Anna <[log in to unmask]> wrote:


	Hello All,

	 

	I'm hoping that someone out there has experienced what I am about to describe.  I am using EAD to encode our organization's finding aids.  A fairly long macro was developed to run through some text to prepare the text (for the controlaccess tag) to be copied into our organization template.  We are using the software, <oXygen/> XML editor, for our templates.  

	 

	My problem is this:  I need to replace an existing macro.  After I copy the newly created macro from notepad, I try to paste it into the software which I will use to run the macro (this would be Visual Basic).  I delete the existing macro there and try to paste the new one in but keep getting "out of memory" error.  I've tried pasting it bit by bit but when I get to a certain point before I can get it all in, I get that "out of memory" error again.  I know I have enough memory since my desktop is fairly new and I've checked the memory.  I've looked online and noticed that there must be some flaw in the software (or some deliberate code) that causes this to happen.  But I don't know what to do to bypass it.  Does anyone have experience with this software?  I'd appreciate any assistance, thoughts, of any kind.

	 

	Thank you!

	 

	Anna Quan Leon

	Reference Librarian

	Palomino Library

	12575 E. Via Linda, Ste 102

	Scottsdale, AZ  85259