| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| storing macros ? | Excel Discussion (Misc queries) | |||
| Storing Formulas to Use | Excel Worksheet Functions | |||
| storing data | Excel Programming | |||
| Storing Data in code? (relative primes to MOD as example) | Excel Programming | |||
| Storing Variables | Excel Programming | |||
Linear Mode
