Saving/Transferring a Macro?

[HLS811]

Hi All,

Heres a new one - which may be a simple answer - but still has me stumped...

Is there a way to save and transfer a macro from one PC to another OTHER than copying over the personal.XLS file??

Currently, thats the way I transfer a macro from one PC to another, but I want to be able to do it without the risk of over-righting something...

Is there a simple way thats staring me in teh face, but I'm too blind to see?

 

[Iridium]

On 2002-10-29 08:31, HLS811 wrote:
Hi All,

Heres a new one - which may be a simple answer - but still has me stumped...

Is there a way to save and transfer a macro from one PC to another OTHER than copying over the personal.XLS file??

Currently, thats the way I transfer a macro from one PC to another, but I want to be able to do it without the risk of over-righting something...

Is there a simple way thats staring me in teh face, but I'm too blind to see?

Try exporting the module/macro to CD-R or floppy then import it on the other PC

 

[HLS811]

On 2002-10-29 08:45, Chris Chattin wrote:

Try exporting the module/macro to CD-R or floppy then import it on the other PC

Sounds easy enough.. Where do I go to export it?

 

[Iridium]

When in Excel hit Alt+F11 to open the VBE. Right click on the module on the project pane containing your macro and select Export - the rest should be simple enough

 

[HLS811]

THANKS!!!