OK, so I'm trying to extract code from a few different projects I've done to make a cute little personal library.
(I'm also working on a project at work documenting rules created in our app, so this will come in handy)
Basically, what I've got so far is a variable that has an entire VB procedure in it. I want to insert that variable into a memo field in Access. Unfortunately, because it's code, there are loads of quotes and spaces and all sorts of things that make it hard to interpert as just one string.
Is there anyway to loop through a paragraph (or a procedure in this case) write each line into a variable and then update a memo field with that variable with out doing a search through the whole string and doubling up the quotes?

Any help is appreciated.