Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copying excel macro
- Thread starter bizee
- Start date
danomaniac
Programmer
Bizee,
here are a few ways...
1. if your code is in a module, you can export the module as a file, then send it to whomever as an attachment, whatever.
Open the Visual Basic Editor, and in the Project Explorer window, (if it's not visible, select 'View'>'Project Explorer') right-click on the code module and select 'Export' - give it a file name and save, you can then import it into another worksheet.
2. You can just copy and paste the code. Select all the code, CTRL C, open Notepad, CTRL V - send the text file to whomever, and reverse the process.
Hope this helps..
Dan
"It's more like it is now, than it ever has been."
here are a few ways...
1. if your code is in a module, you can export the module as a file, then send it to whomever as an attachment, whatever.
Open the Visual Basic Editor, and in the Project Explorer window, (if it's not visible, select 'View'>'Project Explorer') right-click on the code module and select 'Export' - give it a file name and save, you can then import it into another worksheet.
2. You can just copy and paste the code. Select all the code, CTRL C, open Notepad, CTRL V - send the text file to whomever, and reverse the process.
Hope this helps..
Dan
"It's more like it is now, than it ever has been."
- Status
Similar threads
- Locked
- Question