Giving Excel Macros to other people

[skygirl65]

I have macros in my personal workbook that my co-workers need to use. we are not on a network. How can I copy them and e-mail them to someone else and how do they get it into their personal workbook?

 

[SkipVought]

Hi,

You can export the module and attach it to your email. Howeverm since the file extension is .bas, some email clients or virus software might reject the attachnment.

You can also COPY the code and past it into the body of your emial. Then the user must copy 'n' paste from the emaile into a MODULE in their PERSONAL.xls.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[Gavona]

Or save your personal.xls with a different name (say, TeamMacros.xls and share this file with then in the normal way. If they have this file open then the macros will be available to them. You can set the workbook up so it is hidden - then users won't accidentally use it as a blank (new) workbook.


Gavin

 

[SkipVought]

Gavin,

"we are not on a network"

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[Gavona]

Sorry I meant give them this file using a floppy disk, memory stick etc.!


Gavin

 

[KenWright]

Personally, I'd copy your personal.xls and rename it. Then get all the code you want to share in it into a single module, and name the module so that it is obvious what it is.

Email them your new file and have them open it in Excel. Assuming they already have a personal.xls then they can simply use ALT+F11 to go into the VBE, and then drag that one module from your file to their personal.xls

Then just unhide and close the other file and delete it.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------