1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textsharedoptionen01130100xml" indexer="include"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">VBA Properties</title> 31*b1cdbd2cSJim Jagielski <filename>/text/shared/optionen/01130100.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski <section id="office"> 36*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3155805"><bookmark_value>Microsoft Office; importing/exporting VBA code</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>importing; Microsoft Office documents with VBA code</bookmark_value> 38*b1cdbd2cSJim Jagielski <bookmark_value>exporting; Microsoft Office documents with VBA code</bookmark_value> 39*b1cdbd2cSJim Jagielski <bookmark_value>loading; Microsoft Office documents with VBA code</bookmark_value> 40*b1cdbd2cSJim Jagielski <bookmark_value>saving; VBA code in Microsoft Office documents</bookmark_value> 41*b1cdbd2cSJim Jagielski <bookmark_value>VBA code; loading/saving documents with VBA code</bookmark_value> 42*b1cdbd2cSJim Jagielski <bookmark_value>Visual Basic for Applications; loading/saving documents with VBA code</bookmark_value> 43*b1cdbd2cSJim Jagielski</bookmark> 44*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3143267" role="heading" level="1" l10n="U" 45*b1cdbd2cSJim Jagielski oldref="20"><link href="text/shared/optionen/01130100.xhp" name="VBA Properties">VBA Properties</link></paragraph> 46*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150443" role="paragraph" l10n="U" oldref="2"><ahelp hid=".">Specifies the general properties for loading and saving Microsoft Office documents with VBA (Visual Basic for Applications) code.</ahelp></paragraph> 47*b1cdbd2cSJim Jagielski </section> 48*b1cdbd2cSJim Jagielski <section id="howtoget"> 49*b1cdbd2cSJim Jagielski <embed href="text/shared/00/00000406.xhp#etsofi"/> 50*b1cdbd2cSJim Jagielski </section> 51*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3145582" role="heading" level="2" l10n="U" oldref="3">Microsoft Word 97/2000/XP</paragraph> 52*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149762" role="paragraph" l10n="U" oldref="4">Select the settings for Microsoft Word documents.</paragraph> 53*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_CODE" id="bm_id1012200910594212" localize="false"/> 54*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_CODE" id="bm_id101220091104572" localize="false"/> 55*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_PBAS_CODE" id="bm_id1012200911053796" localize="false"/> 56*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3155420" role="heading" level="3" l10n="U" oldref="5">Load Basic code</paragraph> 57*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159399" role="paragraph" l10n="U" oldref="6"><variable id="codetext"><ahelp hid="OFFMGR:CHECKBOX:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_CODE">Loads and saves the Basic code from a Microsoft document as a special $[officename] Basic module with the document. The disabled Microsoft Basic code is visible in the $[officename] Basic IDE between <emph>Sub</emph> and <emph>End Sub</emph>.</ahelp> You can edit the code. When saving the document in $[officename] format, the Basic code is saved as well. When saving in another format, the Basic code from the $[officename] Basic IDE is not saved. 58*b1cdbd2cSJim Jagielski</variable></paragraph> 59*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_STG" id="bm_id1012200911004150" localize="false"/> 60*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_STG" id="bm_id1012200911020741" localize="false"/> 61*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_PBAS_STG" id="bm_id1012200911024686" localize="false"/> 62*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153824" role="heading" level="3" l10n="U" oldref="7">Save original Basic code</paragraph> 63*b1cdbd2cSJim Jagielski <section id="origtext"> 64*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150084" role="paragraph" l10n="CHG" oldref="8"><ahelp hid="OFFMGR:CHECKBOX:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_STG">Specifies that the original Microsoft Basic code contained in the document is held in a special internal memory for as long as the document remains loaded in $[officename]. When saving the document in Microsoft format the Microsoft Basic is saved again with the code in an unchanged form.</ahelp></paragraph> 65*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153088" role="paragraph" l10n="U" oldref="17">When saving in another format than Microsoft Format, the Microsoft Basic Code is not saved. For example, if the document contains Microsoft Basic Code and you save it in $[officename] format, you will be warned that the Microsoft Basic Code will not be saved.</paragraph> 66*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151246" role="paragraph" l10n="U" oldref="18">The <emph>Save original Basic code</emph> checkbox takes precedence over the <emph>Load Basic code</emph> check box. If both boxes are marked and you edit the disabled Basic Code in the $[officename] Basic IDE, the original Microsoft Basic code will be saved when saving in the Microsoft format. A message appears to inform you of this.</paragraph> 67*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148946" role="paragraph" l10n="U" oldref="19">To remove any possible Microsoft Basic macro viruses from the Microsoft document, unmark the <emph>Save Original Basic Code </emph>check box and save the document in Microsoft format. The document will be saved without the Microsoft Basic code.</paragraph> 68*b1cdbd2cSJim Jagielski </section> 69*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154924" role="heading" level="2" l10n="U" oldref="9">Microsoft Excel 97/2000/XP</paragraph> 70*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149457" role="paragraph" l10n="U" oldref="10">Specifies the settings for documents in Microsoft Excel.</paragraph> 71*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154072" role="heading" level="3" l10n="U" 72*b1cdbd2cSJim Jagielski oldref="11">Load Basic code</paragraph> 73*b1cdbd2cSJim Jagielski <embed href="text/shared/optionen/01130100.xhp#codetext"/> 74*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_EXECTBL" id="bm_id1012200911063630" localize="false"/> 75*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id0523200811475727" role="heading" level="3" l10n="NEW">Executable code</paragraph> 76*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id0523200811475733" role="paragraph" l10n="NEW"><ahelp hid=".">The VBA (Visual Basic for Applications) code will be loaded ready to be executed. If this checkbox is not checked, the VBA code will be commented out so it can be inspected, but will not run.</ahelp></paragraph> 77*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3151211" role="heading" level="3" l10n="U" 78*b1cdbd2cSJim Jagielski oldref="12">Save original Basic code</paragraph> 79*b1cdbd2cSJim Jagielski <embed href="text/shared/optionen/01130100.xhp#origtext"/> 80*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3149202" role="heading" level="2" l10n="U" 81*b1cdbd2cSJim Jagielski oldref="13">Microsoft PowerPoint 97/2000/XP</paragraph> 82*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148922" role="paragraph" l10n="U" oldref="14">Specifies the settings for documents in Microsoft PowerPoint.</paragraph> 83*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3148451" role="heading" level="3" l10n="U" 84*b1cdbd2cSJim Jagielski oldref="15">Load Basic code</paragraph> 85*b1cdbd2cSJim Jagielski <embed href="text/shared/optionen/01130100.xhp#codetext"/> 86*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3145419" role="heading" level="3" l10n="U" 87*b1cdbd2cSJim Jagielski oldref="16">Save original Basic code</paragraph> 88*b1cdbd2cSJim Jagielski <embed href="text/shared/optionen/01130100.xhp#origtext"/> 89*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 90*b1cdbd2cSJim Jagielski <embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/> 91*b1cdbd2cSJim Jagielski <embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/> 92*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153768" role="paragraph" l10n="U" oldref="21"><link href="text/shared/optionen/01010200.xhp" name="Setting the default file format">Setting the default file format</link></paragraph> 93*b1cdbd2cSJim Jagielski </section> 94*b1cdbd2cSJim Jagielski </body> 95*b1cdbd2cSJim Jagielski</helpdocument>