Insert txt file as VBA ?

[pookie62]

Hi,

I get on regular bases an xls file by email.
With this file I have to do several things for which I'm trying to create VBA.
What is the easiest way to import this VBA in the file I get ?
Should I create a txt file with the code and copy/paste?
Maybe create a template with code to import the txt file ?
Has anybody done this ?
How would the code look like for importing ?
Thanks..

 

[Andrew Poulsom]

In the VBE right click the module containing your code and choose Export File. Choose a name and location that you can remember (retaining the bas extension) and click Save.

You can the Import this file into the file you get.

 

[pookie62]

Hi Andrew,
Thanks for you reply, but this methode isn't any easier or less work than the copy/paste txt file..
I'm lazy so want to automate as much as possible..
Any other thoughts ?

 

[Andrew Poulsom]

You can automate it with VBA. Follow this link:

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

and read the topic "Copying Modules Between Projects"

 

[pookie62]

Thanks !
This was what I was looking for..