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

F

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
 
D

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:
 
Top