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..
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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 ?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,129
Messages
5,857,537
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top