LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want a macro to save a workbook as a user inputted cell EAHRENS Excel Discussion (Misc queries) 3 November 8th 05 03:28 PM
User to decide how often a macro runs Deedee Excel Discussion (Misc queries) 2 November 2nd 05 08:42 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
Macro to pause for user input in dialog box kayabob Excel Discussion (Misc queries) 1 June 22nd 05 07:49 PM
Macro - Copy - Email John Excel Worksheet Functions 1 March 2nd 05 07:36 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"