Macros

[ds0919]

I am new to creating Macros and as the company trainer, find myself lately creating simple macros for co-workers. I create the macro, test it and it works on my laptop. Now, what is the best way to "give" that macro to my co-worker so that they can use it on their laptop?

[Moo the Dog]

ds,

If the macro is in a separate module, you can export that module to a .bas file, send it to them, then they can import it into a module in their workbook(s).

- Moo

[alansidman]

You could export it as a bas file or a cls file depending on how you created it and email it to your co-worker and have them install it. In the VBE, highlight the macro and click on file, export file. Name it and save it.

Alan

[alansidman]

Moo--beat me to the dessert once again!

[Moo the Dog]

Alan,

Mmm.. cheesecake.

[alansidman]

Moo,
Of course, Cheese in Wisconsin. coozie.JPG Here's a pic of my favorite WI Coozie

[Moo the Dog]

Moo,
Of course, Cheese in Wisconsin. Here's a pic of my favorite WI Coozie

Hah! I have to get one of those...

[arlu1201]

ds0919,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.