Macro to Add VB to a workbook

[eforti]

Hello All,
I currently export data from a program into excel. Once I have the data in excel I run a macro, which is saved in my personal workbook, to remove some of the data. Once the data is removed I send the file to others to work with. I've included some VB data in my personal workbook to do highlighting that I'd like to include in the file when I send it out to others. Right now I'm coping the VB from my personal workbook into the new workbook before I send it. Is there any way to automate this process through a macro?

I.e. I want to update my macro to include the addition of specific VB coding into the active workbook (not my personal workbook).

Does this make sense?

Thanks in advance for any help.

 

[VoG]

This should help you http://www.cpearson.com/excel/VBE.aspx