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

storing of VBA code
 

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

storing of VBA code
 

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

--
Regards,
Tom Ogilvy

"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

storing of VBA code
 

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

storing of VBA code
 

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