You can right click on the module, class module or form you wish to export
and then select Export. The resulting file, if it's a module or class module
is a plain text file, but the form is saved in a VB form format.

The modules, when exported, can be opened by any text editor, or reimported
into any office document.
--
Kevin Backmann


"Bob Phillips" wrote:

But you can export that code module, and open the exported file in any text
editor.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Chip Pearson" wrote in message
...
VBA is stored in the workbook file. It is stored as a binary
format, never as straight text. Translation from this binary
format to the text you see on the screen is done when you view
code in the VBA Editor.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kurt" wrote in message
oups.com...
Hi

Anyone know where the VBA code actually are stored and in what
format
and is it
awailebel from the VBA editor og vis the Locals


Kurt