VBE

[LAS]

Does anyone have code to import code sitting in a text file into a module?

Thanks

Lawrence

 

[Aaron Blood]

On 2002-12-17 16:58, NateO wrote:
Howdy y'all, might want to have a look at:

http://www.cpearson.com/excel/vbe.htm

The section on copying modules between projects. You won't want the export, but the import could be handy.

Another way to pluck a duck. E.g.,<pre>
Sub ImportModule()
Dim FName As String
FName = "c:tempcode.txt"
ThisWorkbook.VBProject.VBComponents.Import FName
End Sub</pre>

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-12-17 17:45

This one doesn't seem to like notepad text documents either. Hmmm...

Alright, I'm just gonna throw out notepad!
This message was edited by Aaron Blood on 2002-12-18 10:25

 

[Aaron Blood]

Alright I finally figured out my notepad textfile problem...

I had the textfile encoding set to "Unicode" when saving the textfile in Notepad.

If I set the encoding to ANSI and save it order returns to the universe.