1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 224486111Smseidel 30ba1032bSAndrew Rist<!--*********************************************************** 424486111Smseidel * 50ba1032bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 60ba1032bSAndrew Rist * or more contributor license agreements. See the NOTICE file 70ba1032bSAndrew Rist * distributed with this work for additional information 80ba1032bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 90ba1032bSAndrew Rist * to you under the Apache License, Version 2.0 (the 100ba1032bSAndrew Rist * "License"); you may not use this file except in compliance 110ba1032bSAndrew Rist * with the License. You may obtain a copy of the License at 1224486111Smseidel * 130ba1032bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1424486111Smseidel * 150ba1032bSAndrew Rist * Unless required by applicable law or agreed to in writing, 160ba1032bSAndrew Rist * software distributed under the License is distributed on an 170ba1032bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 180ba1032bSAndrew Rist * KIND, either express or implied. See the License for the 190ba1032bSAndrew Rist * specific language governing permissions and limitations 200ba1032bSAndrew Rist * under the License. 2124486111Smseidel * 220ba1032bSAndrew Rist ***********************************************************--> 230ba1032bSAndrew Rist 2424486111Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 2624486111Smseidel<topic id="textsharedoptionen01130100xml" indexer="include"> 2724486111Smseidel<title xml-lang="en-US" id="tit">VBA Properties</title> 2824486111Smseidel<filename>/text/shared/optionen/01130100.xhp</filename> 2924486111Smseidel</topic> 3024486111Smseidel</meta> 3124486111Smseidel<body> 3224486111Smseidel<section id="office"> 3324486111Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155805"> 3424486111Smseidel<bookmark_value>Microsoft Office; importing/exporting VBA code</bookmark_value> 3524486111Smseidel<bookmark_value>importing; Microsoft Office documents with VBA code</bookmark_value> 3624486111Smseidel<bookmark_value>exporting; Microsoft Office documents with VBA code</bookmark_value> 3724486111Smseidel<bookmark_value>loading; Microsoft Office documents with VBA code</bookmark_value> 3824486111Smseidel<bookmark_value>saving; VBA code in Microsoft Office documents</bookmark_value> 3924486111Smseidel<bookmark_value>VBA code; loading/saving documents with VBA code</bookmark_value> 4024486111Smseidel<bookmark_value>Visual Basic for Applications; loading/saving documents with VBA code</bookmark_value> 41cdf0e10cSrcweir</bookmark> 42cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3143267" role="heading" level="1" l10n="U" 4324486111Smseideloldref="20"><link href="text/shared/optionen/01130100.xhp" name="VBA Properties">VBA Properties</link></paragraph> 4424486111Smseidel<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> 4524486111Smseidel</section> 4624486111Smseidel<section id="howtoget"> 4724486111Smseidel<embed href="text/shared/00/00000406.xhp#etsofi"/> 4824486111Smseidel</section> 4924486111Smseidel<paragraph xml-lang="en-US" id="hd_id3145582" role="heading" level="2" l10n="U" oldref="3">Microsoft Word 97/2000/XP</paragraph> 5024486111Smseidel<paragraph xml-lang="en-US" id="par_id3149762" role="paragraph" l10n="U" oldref="4">Select the settings for Microsoft Word documents.</paragraph> 51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_CODE" id="bm_id1012200910594212" localize="false"/> 52cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_CODE" id="bm_id101220091104572" localize="false"/> 53cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_PBAS_CODE" id="bm_id1012200911053796" localize="false"/> 54cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155420" role="heading" level="3" l10n="U" oldref="5">Load Basic code</paragraph> 5524486111Smseidel<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. 56cdf0e10cSrcweir</variable></paragraph> 57cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_WBAS_STG" id="bm_id1012200911004150" localize="false"/> 58cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_STG" id="bm_id1012200911020741" localize="false"/> 59cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_PBAS_STG" id="bm_id1012200911024686" localize="false"/> 60cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153824" role="heading" level="3" l10n="U" oldref="7">Save original Basic code</paragraph> 6124486111Smseidel<section id="origtext"> 6224486111Smseidel<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> 6324486111Smseidel<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> 6424486111Smseidel<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> 65*bdc40920Smseidel<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> 6624486111Smseidel</section> 6724486111Smseidel<paragraph xml-lang="en-US" id="hd_id3154924" role="heading" level="2" l10n="U" oldref="9">Microsoft Excel 97/2000/XP</paragraph> 6824486111Smseidel<paragraph xml-lang="en-US" id="par_id3149457" role="paragraph" l10n="U" oldref="10">Specifies the settings for documents in Microsoft Excel.</paragraph> 6924486111Smseidel<paragraph xml-lang="en-US" id="hd_id3154072" role="heading" level="3" l10n="U" 7024486111Smseideloldref="11">Load Basic code</paragraph> 7124486111Smseidel<embed href="text/shared/optionen/01130100.xhp#codetext"/> 72cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/svx:CheckBox:RID_OFAPAGE_MSFILTEROPT:CB_EBAS_EXECTBL" id="bm_id1012200911063630" localize="false"/> 73cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id0523200811475727" role="heading" level="3" l10n="NEW">Executable code</paragraph> 7424486111Smseidel<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> 7524486111Smseidel<paragraph xml-lang="en-US" id="hd_id3151211" role="heading" level="3" l10n="U" 7624486111Smseideloldref="12">Save original Basic code</paragraph> 7724486111Smseidel<embed href="text/shared/optionen/01130100.xhp#origtext"/> 7824486111Smseidel<paragraph xml-lang="en-US" id="hd_id3149202" role="heading" level="2" l10n="U" 7924486111Smseideloldref="13">Microsoft PowerPoint 97/2000/XP</paragraph> 8024486111Smseidel<paragraph xml-lang="en-US" id="par_id3148922" role="paragraph" l10n="U" oldref="14">Specifies the settings for documents in Microsoft PowerPoint.</paragraph> 8124486111Smseidel<paragraph xml-lang="en-US" id="hd_id3148451" role="heading" level="3" l10n="U" 8224486111Smseideloldref="15">Load Basic code</paragraph> 8324486111Smseidel<embed href="text/shared/optionen/01130100.xhp#codetext"/> 8424486111Smseidel<paragraph xml-lang="en-US" id="hd_id3145419" role="heading" level="3" l10n="U" 8524486111Smseideloldref="16">Save original Basic code</paragraph> 8624486111Smseidel<embed href="text/shared/optionen/01130100.xhp#origtext"/> 8724486111Smseidel<section id="relatedtopics"> 8824486111Smseidel<embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/> 8924486111Smseidel<embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/> 9024486111Smseidel<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> 9124486111Smseidel</section> 9224486111Smseidel</body> 9324486111Smseidel</helpdocument> 94