If you are supposed to work with a new computer with newly installed office, and want to run a code that you have its source with you to the active document, what would be the fastest way to run it?



What I think is that to open the visual basic, copy/paste my code and select the Sub I want to run and just F5? Is there any other way like making that code a .vbs and opening it or somehow importing it over the active document? or any other method? I am looking for some kind of portable method that makes me able to have it with me anywhere and run it over any document in any Word, without having to create a Macro or button on the toolbar or using my own Normal.dot.

Thanks in advance for letting me know what you think.

You could export the code module from your current document. Then, for your new document, import the code module. I doubt that's much quicker than simply saving the code as a plain text file (by copying & pasting into notepad), then copying & pasting from there into a code module in the new document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

If I import it, will it be saved in the current document? or in Normal.dot? It means if I send my document, the code will be with it too?

Do you know any shortcut for opening visual basic in Word?

That depends on which you import it into.
Alt-F11

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for your reply.