Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion Standard

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

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.