how do I import and export a macro in excel so other people can us

[Guest]

 

[Frank Kabel]

Hi
one way: Create an addin which the other users can install

 

[Frank Stone]

hi,
to export:
In the vb editor, right click the module then click export.
it will export as a .bas text file. give it a name. click
save. you can save it to a floppy for easy upload to
another pc.
to import:
in the vb editor, right click the project then click
import.
find the file you named above and click open.
regards
Frank

 

[Dave Peterson]

You could just give them the workbook that contains the macro.

Tell them to open that file and then tools|macro|macros and run your macro.



rad wrote: