Sending a macro to another PC-how?

  • Thread starter Thread starter KSH
  • Start date Start date
K

KSH

How do you send a macro you've written to another PC so
that they can save it in their Personal.xls file (at
Program Files\Microsoft Office\Office\XLStart)?
 
You can export a macro and save it, to do this from your workbook,
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, 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 new workbook.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
highlight the code in the VBA editor and paste it in Word or similar, send
to the other and paste in the personal.xls VBA editor of the other PC.

HTH Gilles
 
In the VBA Editor, open the module containing the macro, then go to the File
menu, choose Export. This will create a file called Module1.bas or something
similar. You can then send this file to other users. The user can import
this file in to his personal.xls file by opening Personal.xls in the VBA
editor and choosing Import from the File menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
KSH,

Go into the VBA Editor (Alt + F11)
Open the Personal.xls in the Projects window.
Create a new module in Personal.xls. (name it something unique
so that there won't be any conflicts at the receiving end)
Cut and paste (not copy and paste) the macro that you want to send into
this new module.
Right click on the module and export it. (It'll be a .bas file. Take note of
where it's saved).
Send that .bas file to whomever you want.
Have them import it into their Personal.xls

John
 
Back
Top