storing of VBA code

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

It is stored in the workbook file along with everything else. You can
export a copy of the code.

--
Regards,
Tom Ogilvy

"kurt" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:uRF%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>

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" <[email protected]> wrote in message
> news:uRF%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> >
> >
>
>
>