| Post ID |
Timestamp |
Content |
User |
| 181438 |
2003-10-08 19:49:00 |
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 |
johut (4183) |
| 181439 |
2003-10-08 20:03:00 |
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. |
parry (27) |
| 181440 |
2003-10-11 19:15:00 |
thanks a million - worked great 8-) |
johut (4183) |
| 1 |
|