macro to copy vba macro

[sassriverrat]

I was hoping someone might be able to give me some code to help me copy the contents of a macro, i.e. the coding itself, into a text file. The name of the macro can be "module1" for the sake of the argument. Thank you!

 

[CalcSux78]

Chip Pearson (R.I.P.) has a page on copying code to a text file: http://www.cpearson.com/Excel/vbe.aspx (Scroll half way down or do a search for "Code Module To A Text File")

Please read through the Intro as there are some settings that need to be changed to get the code to work.

 

[sassriverrat]

that was part of the problem....I don't want to change settings because this is being sent out to about 130 computers....