# Sending an Excel Macro **URL:** \ **Category:** Factual Questions\ **Created:** [June 24, 2003, 6:46pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184099 "2003-06-24T18:46:40Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![daniel801](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@daniel801](https://boards.straightdope.com/u/daniel801)\ **Post date:** [June 24, 2003, 6:46pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184099/1 "2003-06-24T18:46:40Z")
Excel. I created a macro and saved in my personal.xls How do I send it to a co-worker’s computer and how does he then get the macro saved to his personal.xls? Thanks. ---
**Author:** ![griffin77](https://avatars.discourse-cdn.com/v4/letter/g/3d9bf3/32.png) [@griffin77](https://boards.straightdope.com/u/griffin77)\ **Post date:** [June 24, 2003, 7:12pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184099/2 "2003-06-24T19:12:19Z")
On Office 2000: - Goto tools\>macro\>macros. - Select your macro and click edit, this will bring up Microsoft Visual Basic Editor. - Select file\>export file, save your macro as a bas file - Email it to your co-worker, test him to do the same except click on “import file” instead of "export file. Then save… Its possible you may have sending .BAS files via the mail (I don’t know is outlook, treats .bas files as “suspect”). If so rename it before/after sending. ---
**Author:** ![AllShookDown](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@AllShookDown](https://boards.straightdope.com/u/AllShookDown)\ **Post date:** [June 24, 2003, 10:04pm UTC](https://boards.straightdope.com/t/sending-an-excel-macro/184099/3 "2003-06-24T22:04:06Z")
Save your personal.xls file with a different file name (or copy it and rename it). Delete all the macros except the ones you want your co-worker to have. Send that file.