1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textsharedoptionen01130100xml" indexer="include">
<title id="tit" xml-lang="en-US">VBA Properties</title>
<filename>/text/shared/optionen/01130100.xhp</filename>
</topic>
</meta>
<body>
<section id="office">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155805">
<bookmark_value>Microsoft Office; importing/exporting VBA code</bookmark_value>
<bookmark_value>importing; Microsoft Office documents with VBA code</bookmark_value>
<bookmark_value>exporting; Microsoft Office documents with VBA code</bookmark_value>
<bookmark_value>loading; Microsoft Office documents with VBA code</bookmark_value>
<bookmark_value>saving; VBA code in Microsoft Office documents</bookmark_value>
<bookmark_value>VBA code; loading/saving documents with VBA code</bookmark_value>
<bookmark_value>Visual Basic for Applications; loading/saving documents with VBA code</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/OptFltrPage" id="bm_id1012200911063620" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/@@nowidget@@" id="bm_id1012200911063620" localize="false"/>
<h1 id="hd_id3143267"><link href="text/shared/optionen/01130100.xhp" name="VBA Properties">VBA Properties</link></h1>
<paragraph id="par_id3150443" role="paragraph" xml-lang="en-US"><ahelp hid=".">Specifies the general properties for loading and saving Microsoft Office documents with VBA (Visual Basic for Applications) code.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#etsofi"/>
</section>
<embed href="text/shared/06/optionen_screenshots.xhp#optionfilterdialog"/>
<h2 id="hd_id3145582">Microsoft Word 97/2000/XP</h2>
<paragraph id="par_id3149762" role="paragraph" xml-lang="en-US">Select the settings for Microsoft Word documents.</paragraph>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/wo_basic" id="bm_id1012200910594212" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/ex_basic" id="bm_id101220091104572" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/pp_basic" id="bm_id1012200911053796" localize="false"/>
<h3 id="hd_id3155420">Load Basic code</h3>
<paragraph id="par_id3159399" role="paragraph" xml-lang="en-US"><variable id="codetext"><ahelp hid=".">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. </variable></paragraph>
<section id="executablecode">
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/wo_exec" id="bm_id1012200911063630" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/ex_exec" id="bm_id1012200911063631" localize="false"/>
<h3 id="hd_id0523200811475727">Executable code</h3>
<paragraph id="par_id0523200811475733" role="paragraph" xml-lang="en-US"><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>
<tip id="par_id05172017121531273">After loading the VBA code, %PRODUCTNAME inserts the statement <item type="literal">Option VBASupport 1</item> in every Basic module to enable a limited support for VBA statements, functions and objects. See <link href="text/sbasic/shared/03103350.xhp">Option VBASupport Statement</link> for more information.</tip>
</section>
<h3 id="hd_id3153824">Save original Basic code</h3>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/wo_saveorig" id="bm_id1012200911004150" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/ex_saveorig" id="bm_id1012200911020741" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/optfltrpage/pp_saveorig" id="bm_id1012200911024686" localize="false"/>
<section id="origtext">
<paragraph id="par_id3150084" role="paragraph" xml-lang="en-US"><ahelp hid=".">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>
<paragraph id="par_id3153088" role="paragraph" xml-lang="en-US">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>
<paragraph id="par_id3151246" role="paragraph" xml-lang="en-US">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>
<paragraph id="par_id3148946" role="paragraph" xml-lang="en-US">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>
</section>
<h2 id="hd_id3154924">Microsoft Excel 97/2000/XP</h2>
<paragraph id="par_id3149457" role="paragraph" xml-lang="en-US">Specifies the settings for documents in Microsoft Excel.</paragraph>
<h3 id="hd_id3154072">Load Basic code</h3>
<embed href="text/shared/optionen/01130100.xhp#codetext"/>
<embed href="text/shared/optionen/01130100.xhp#executablecode"/>
<h3 id="hd_id3151211">Save original Basic code</h3>
<embed href="text/shared/optionen/01130100.xhp#origtext"/>
<h2 id="hd_id3149202">Microsoft PowerPoint 97/2000/XP</h2>
<paragraph id="par_id3148922" role="paragraph" xml-lang="en-US">Specifies the settings for documents in Microsoft PowerPoint.</paragraph>
<h3 id="hd_id3148451">Load Basic code</h3>
<embed href="text/shared/optionen/01130100.xhp#codetext"/>
<h3 id="hd_id3145419">Save original Basic code</h3>
<embed href="text/shared/optionen/01130100.xhp#origtext"/>
<section id="relatedtopics">
<embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/>
<embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/>
<paragraph id="par_id3153768" role="paragraph" xml-lang="en-US"><link href="text/shared/optionen/01010200.xhp" name="Setting the default file format">Setting the default file format</link></paragraph>
<paragraph id="par_id051720170430585307" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/vbasupport.xhp">VBA support in %PRODUCTNAME</link></paragraph>
</section>
</body>
</helpdocument>
|
