Saving macros from Personal xls

[inarbeth]

I want to save the macros I have created (and which are stored in Modules in personal.xls) to a jumpdrive. This is (a) to back them up and (b) to have useful code if I use Excel on another machine. Is there a way to be this en bloc without having to cut and paste individual macros?

 

[jimbojones]

Hi,

If you go into VBE and then make sure you can see the Project Viewer.

Right click the module and select Export. Then you can save it to your desktop as a *.BAS file then copy to jump drive.

You can import these file types in a similar way.

Any use?

James

 

[inarbeth]

Many thanks - that works fine. It's a pity you can't export all the modules in one go but I've selected the ones I need.

 

[klb]

Of course, you could just copy your personal.xls to the jump drive.