Macro to Add VB to a workbook

eforti

Board Regular
Joined
Aug 15, 2005
Messages
220
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.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,123,320
Messages
5,600,940
Members
414,417
Latest member
Nobu

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