View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default HOw DO I EMAIL AN EXEL MACRO TO ANTOEHR USER?

Leo, you can export a macro and save it, to do this from excel, right-click
the workbook's icon and pick View Code. This icon is to the left of the
"File" menu this will open the VBA editor, in Project Explorer click on the
module you want, if you don't see it press CTRL + r to open the Project
Explorer then click on the module you want to save and go to file and export
file, then save it to a floppy or what ever you backup to, then import it to
the other computer.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"leo" wrote in message
...
I have excel macro that get stored in xl file "personnel". when i open

the
"personneL" file i can't see any data in it. that being said how do i

email a
macro if i can't even see the macro file.