Insert txt file as VBA ?

pookie62

New Member
Joined
Oct 20, 2005
Messages
21
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..
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Oct 20, 2005
Messages
21
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.. :cool:
Any other thoughts ?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,367
Members
410,911
Latest member
AniEx
Top