PDA

View Full Version : exporting Excel macros



johut
09-10-2003, 08:49 AM
I've prepared a number of Excel macros which I want to put on another machine. Is it possible to do this and, if so, how do I go about it please

parry
09-10-2003, 09:03 AM
Hi, first open the VB Editor (alt-f11). On the left hand window is the VB Project window and you should see a folder called Modules. Open the folder then right click the modules there (eg Module1) and select Export file and it saves as a BAS extension.

In the new book, open the VBE then select File-Import File and select the BAS file you want to import.

johut
12-10-2003, 08:15 AM
thanks a million - worked great 8-)