Christof has attended:
Excel Advanced course
Macros
Is there a way to export Macros and send them for an import? How can I easily transfer them. I already established, that I can send them as TXT...
RE: Macros
Hi Christof, Thank you for the post,
You would usually only export the macro as text.
In Excel press ALT + F11 to bring up the VB editor. In the project explorer window on the left you should see the module containing your macro code. Just right click the module and select "EXPORT." Export to a floppy or your network drive or even email the module to yourself.
Follow the same directions on the other computer except select the "IMPORT" options and point to your saved module.
I hope that helps, best regards Pete