AllLangHelp_sbasic.mk | 2
source/text/sbasic/shared/03103350.xhp | 71 ++++++++++++++++
source/text/sbasic/shared/main0601.xhp | 38 ++++----
source/text/sbasic/shared/vbasupport.xhp | 55 ++++++++++++
source/text/shared/optionen/01130100.xhp | 134 ++++++++++++++++++-------------
5 files changed, 227 insertions(+), 73 deletions(-)
New commits:
commit 6f947c50faf2969405749fc118659d9d9934eb91
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Wed May 17 16:34:06 2017 -0300
tdf#84675 (part4) document VBA macros support
Change-Id: I61f60fb4f3ac27604a71972f0c1d8a7e9effdcc4
Reviewed-on: https://gerrit.libreoffice.org/37735
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index 4ac32080b..1be0b6bbe 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -252,6 +252,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/03103100 \
helpcontent2/source/text/sbasic/shared/03103200 \
helpcontent2/source/text/sbasic/shared/03103300 \
+ helpcontent2/source/text/sbasic/shared/03103350 \
helpcontent2/source/text/sbasic/shared/03103400 \
helpcontent2/source/text/sbasic/shared/03103450 \
helpcontent2/source/text/sbasic/shared/03103500 \
@@ -324,6 +325,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/keys \
helpcontent2/source/text/sbasic/shared/main0211 \
helpcontent2/source/text/sbasic/shared/main0601 \
+ helpcontent2/source/text/sbasic/shared/vbasupport \
))
# vim: set noet sw=4 ts=4:
diff --git a/source/text/sbasic/shared/03103350.xhp
b/source/text/sbasic/shared/03103350.xhp
new file mode 100644
index 000000000..6cd1eb426
--- /dev/null
+++ b/source/text/sbasic/shared/03103350.xhp
@@ -0,0 +1,71 @@
+<?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="textsbasicshared03103300xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Option VBASupport Statement
[Runtime]</title>
+ <filename>/text/sbasic/shared/03103350.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+
+<section id="optioniVBASupport">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145090">
+ <bookmark_value>MS Excel macros support;Enable</bookmark_value>
+ <bookmark_value>MS Excel macros support;Option VBASupport
statement</bookmark_value>
+ <bookmark_value>VBA Support;Option VBASupport statement</bookmark_value>
+ <bookmark_value>Option VBASupport statement</bookmark_value>
+</bookmark>
+
+
+<paragraph id="hd_id3145090" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03103300.xhp" name="Option Explicit Statement
[Runtime]">Option VBASupport Statement [Runtime]</link></paragraph>
+<paragraph id="par_id3148538" role="paragraph" xml-lang="en-US">Specifies that
%PRODUCTNAME Basic will support some VBA statements, functions and
objects.</paragraph>
+</section>
+<paragraph id="par_id051720171055367194" role="note" xml-lang="en-US">The
support for VBA is not complete, but covers a large portion of the common usage
patterns.</paragraph>
+
+<paragraph id="hd_id3149763" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<bascode>
+<paragraph id="par_id3149514" role="bascode" localize="false"
xml-lang="en-US">Option VBASupport {1|0}</paragraph>
+</bascode>
+
+<paragraph id="hd_id3145315" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<paragraph id="par_id3145172" role="warning" xml-lang="en-US">This statement
must be added before the executable program code in a module.</paragraph>
+<paragraph id="par_id051720171055361727" role="paragraph" xml-lang="en-US">1:
Enable VBA support in %PRODUCTNAME</paragraph>
+<paragraph id="par_id051720171055369857" role="paragraph" xml-lang="en-US">0:
Disable VBA support</paragraph>
+
+<paragraph id="hd_id3125864" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<bascode>
+<paragraph id="par_idm1340938880" role="bascode" localize="false"
xml-lang="en-US">Option VBASupport 1</paragraph>
+<paragraph id="par_idm1340937648" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleVBA</paragraph>
+<paragraph id="par_id051720171055368852" role="bascode" localize="false"
xml-lang="en-US">Dim sVar As Single</paragraph>
+<paragraph id="par_id051720171055369387" role="bascode" localize="false"
xml-lang="en-US"> sVar = Worksheets("Sheet1").Range("A1")</paragraph>
+<paragraph id="par_id051720171055365423" role="bascode" localize="false"
xml-lang="en-US">Print sVar</paragraph>
+<paragraph id="par_idm1340929616" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
+</bascode>
+
+<section id="relatedtopics">
+<paragraph id="par_id051720171119254111" role="paragraph"
xml-lang="en-US"><link href="text/shared/optionen/01130100.xhp">VBA
Properties</link></paragraph>
+<paragraph id="par_id051720170424259343" role="paragraph"
xml-lang="en-US"><link href="text/sbasic/shared/vbasupport.xhp">VBA support in
%PRODUCTNAME</link></paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/sbasic/shared/main0601.xhp
b/source/text/sbasic/shared/main0601.xhp
index 45324adca..e9e9e5016 100644
--- a/source/text/sbasic/shared/main0601.xhp
+++ b/source/text/sbasic/shared/main0601.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -17,27 +16,27 @@
* 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 .
- -->
+-->
-
-<helpdocument version="1.0">
<meta>
-<topic id="textsbasicsharedmain0601xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">$[officename] Basic Help</title>
-<filename>/text/sbasic/shared/main0601.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textsbasicsharedmain0601xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">$[officename] Basic Help</title>
+ <filename>/text/sbasic/shared/main0601.xhp</filename>
+ </topic>
</meta>
+
<body>
+
<bookmark xml-lang="en-US" branch="hid/HID_GLOBAL_FALLBACK" id="bm_id3143284"
localize="false"/>
-<paragraph role="heading" id="hd_id3154232" xml-lang="en-US" level="1"><link
href="text/sbasic/shared/main0601.xhp" name="$[officename] Basic
Help">%PRODUCTNAME Basic Help</link></paragraph>
+
+<paragraph id="hd_id3154232" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/main0601.xhp" name="$[officename] Basic
Help">%PRODUCTNAME Basic Help</link></paragraph>
+
<section id="basicalt">
-<paragraph role="paragraph" id="par_id3153894" xml-lang="en-US">%PRODUCTNAME
provides an Application Programming Interface (API) that allows controlling the
$[officename] components with different programming languages by using the
$[officename] Software Development Kit (SDK). For more information about the
$[officename] API and the Software Development Kit, visit <link
href="http://api.libreoffice.org/";
name="http://api.libreoffice.org";>http://api.libreoffice.org</link></paragraph>
-<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">This help
section explains the most common runtime functions of %PRODUCTNAME Basic. For
more in-depth information please refer to the <link
href="http://wiki.documentfoundation.org/Documentation/BASIC_Guide";>OpenOffice.org
BASIC Programming Guide</link> on the Wiki.</paragraph>
+<paragraph id="par_id3153894" role="paragraph" xml-lang="en-US">%PRODUCTNAME
provides an Application Programming Interface (API) that allows controlling the
$[officename] components with different programming languages by using the
$[officename] Software Development Kit (SDK). For more information about the
$[officename] API and the Software Development Kit, visit <link
href="http://api.libreoffice.org/";
name="http://api.libreoffice.org";>http://api.libreoffice.org</link></paragraph>
+<paragraph id="par_id3147226" role="paragraph" xml-lang="en-US">This help
section explains the most common runtime functions of %PRODUCTNAME Basic. For
more in-depth information please refer to the <link
href="http://wiki.documentfoundation.org/Documentation/BASIC_Guide";>OpenOffice.org
BASIC Programming Guide</link> on the Wiki.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3146957" xml-lang="en-US" level="3">Working
with %PRODUCTNAME Basic</paragraph>
+
+<paragraph id="hd_id3146957" role="heading" level="3" xml-lang="en-US">Working
with %PRODUCTNAME Basic</paragraph>
<embed href="text/sbasic/shared/01000000.xhp#doc_title"/>
<embed href="text/sbasic/shared/03000000.xhp#doc_title"/>
<embed href="text/shared/guide/macro_recording.xhp#macro_recording"/>
@@ -46,7 +45,9 @@
<embed href="text/sbasic/guide/control_properties.xhp#control_properties"/>
<embed href="text/sbasic/guide/show_dialog.xhp#show_dialog"/>
<embed href="text/sbasic/guide/sample_code.xhp#sample_code"/>
-<paragraph role="heading" id="hd_id3148473" xml-lang="en-US" level="3">Help
about the Help</paragraph>
+<embed href="text/sbasic/shared/vbasupport.xhp#support_for_vba_macros"/>
+
+<paragraph id="hd_id3148473" role="heading" level="3" xml-lang="en-US">Help
about the Help</paragraph>
<embed href="text/shared/05/00000100.xhp#neuehilfe"/>
<embed href="text/shared/05/00000110.xhp#00000110"/>
<embed href="text/shared/05/00000120.xhp#00000120"/>
@@ -55,4 +56,5 @@
<embed href="text/shared/05/00000150.xhp#doc_title"/>
<embed href="text/shared/05/00000160.xhp#doc_title"/>
</body>
-</helpdocument>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/sbasic/shared/vbasupport.xhp
b/source/text/sbasic/shared/vbasupport.xhp
new file mode 100644
index 000000000..694afd33c
--- /dev/null
+++ b/source/text/sbasic/shared/vbasupport.xhp
@@ -0,0 +1,55 @@
+<?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="textsbasicsharedvbasupportxml">
+ <title id="tit" xml-lang="en-US">Support for VBA Macros</title>
+ <filename>/text/sbasic/shared/vbasupport.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+
+<section id="support_for_vba_macros">
+
+<paragraph id="hd_id051720170332046289" role="heading" level="1"
xml-lang="en-US"><link href="text/sbasic/shared/vbasupport.xhp">Working with
VBA Macros</link></paragraph>
+<paragraph id="par_id05172017033242490" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Visual Basic for Applications (VBA) is an
implementation of Microsoft's Visual Basic which is built into all Microsoft
Office applications. </ahelp></paragraph>
+</section>
+<paragraph id="par_id051720170332428854" role="paragraph"
xml-lang="en-US">Support for VBA is not complete, but it covers a large portion
of the common usage patterns. Most macros use a manageable subset of objects in
the Excel API (such as the Range, Worksheet, Workbook, etc.) and the support
include those objects, and the most commonly used method/properties of those
objects.</paragraph>
+
+<paragraph id="hd_id051720170350145604" role="heading" level="2"
xml-lang="en-US">Loading Microsoft Office documents with executable VBA
macros</paragraph>
+<paragraph id="par_id051720170350147298" role="paragraph" xml-lang="en-US">Go
to <item type="menuitem">Tools â Options â Load / Save â VBA
Properties</item> and mark the <emph>Excutable code</emph> checkbox. Then load
or open your document.</paragraph>
+<embed href="text/shared/optionen/01130100.xhp#executablecode"/>
+
+<paragraph id="hd_id051720170400536628" role="heading" level="2"
xml-lang="en-US">Runing VBA Macros</paragraph>
+<paragraph id="par_id051720170400539565" role="paragraph" xml-lang="en-US">Run
VBA macros in the same way as %PRODUCTNAME Basic macros.</paragraph>
+<paragraph id="par_id051720170407404013" role="warning" xml-lang="en-US">Since
support for VBA is not complete, you may have to edit the VBA code and complete
the missing support with %PRODUCTNAME Basic objects, statements and
functions.</paragraph>
+
+<paragraph id="hd_id051720170400533411" role="heading" level="2"
xml-lang="en-US">Editing VBA Macros</paragraph>
+<paragraph id="par_id051720170400532486" role="paragraph" xml-lang="en-US">VBA
macros can be edited in the %PRODUCTNAME Basic IDE.</paragraph>
+
+<section id="relatedtopics">
+<paragraph id="par_id051720171119254111" role="paragraph"
xml-lang="en-US"><link href="text/shared/optionen/01130100.xhp">VBA
Properties</link></paragraph>
+<paragraph id="par_id051720170407401872" role="paragraph"
xml-lang="en-US"><link href="text/sbasic/shared/01030000.xhp">%PRODUCTNAME
Basic IDE</link></paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/shared/optionen/01130100.xhp
b/source/text/shared/optionen/01130100.xhp
index c0c32e4f0..3ab6d9c1e 100644
--- a/source/text/shared/optionen/01130100.xhp
+++ b/source/text/shared/optionen/01130100.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,69 +16,94 @@
* 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 xml-lang="en-US" id="tit">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>
+ <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"/>
-<paragraph xml-lang="en-US" id="hd_id3143267" role="heading" level="1"
><link href="text/shared/optionen/01130100.xhp" name="VBA
Properties">VBA Properties</link></paragraph>
- <paragraph xml-lang="en-US" id="par_id3150443"
role="paragraph"><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>
- <paragraph xml-lang="en-US" id="hd_id3145582" role="heading"
level="2">Microsoft Word 97/2000/XP</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149762" role="paragraph">Select
the settings for Microsoft Word documents.</paragraph>
+
+<paragraph id="hd_id3143267" role="heading" level="1" xml-lang="en-US"><link
href="text/shared/optionen/01130100.xhp" name="VBA Properties">VBA
Properties</link></paragraph>
+<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>
+
+<paragraph id="hd_id3145582" role="heading" level="2"
xml-lang="en-US">Microsoft Word 97/2000/XP</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="hd_id3155420" role="heading" level="3">Load
Basic code</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159399"
role="paragraph"><variable id="codetext"><ahelp
hid="cui/ui/optfltrpage/wo_basic">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>
+
+<paragraph id="hd_id3155420" role="heading" level="3" xml-lang="en-US">Load
Basic code</paragraph>
+<paragraph id="par_id3159399" role="paragraph" xml-lang="en-US"><variable
id="codetext"><ahelp hid="cui/ui/optfltrpage/wo_basic">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>
<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"/>
-<paragraph xml-lang="en-US" id="hd_id3153824" role="heading" level="3">Save
original Basic code</paragraph>
- <section id="origtext">
- <paragraph xml-lang="en-US" id="par_id3150084"
role="paragraph"><ahelp hid="cui/ui/optfltrpage/wo_saveorig">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 xml-lang="en-US" id="par_id3153088" role="paragraph">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 xml-lang="en-US" id="par_id3151246" role="paragraph">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 xml-lang="en-US" id="par_id3148946" role="paragraph">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>
- <paragraph xml-lang="en-US" id="hd_id3154924" role="heading"
level="2">Microsoft Excel 97/2000/XP</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149457"
role="paragraph">Specifies the settings for documents in Microsoft
Excel.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154072" role="heading" level="3"
>Load Basic code</paragraph>
- <embed href="text/shared/optionen/01130100.xhp#codetext"/>
+
+<section id="executablecode">
+
+<paragraph id="hd_id0523200811475727" role="heading" level="3"
xml-lang="en-US">Executable code</paragraph>
+<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>
+<paragraph id="par_id05172017121531273" role="tip" xml-lang="en-US">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
[Runtime]</link> for more information.</paragraph>
+</section>
+
+<paragraph id="hd_id3153824" role="heading" level="3" xml-lang="en-US">Save
original Basic code</paragraph>
+
+<section id="origtext">
+<paragraph id="par_id3150084" role="paragraph" xml-lang="en-US"><ahelp
hid="cui/ui/optfltrpage/wo_saveorig">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>
+
+<paragraph id="hd_id3154924" role="heading" level="2"
xml-lang="en-US">Microsoft Excel 97/2000/XP</paragraph>
+<paragraph id="par_id3149457" role="paragraph" xml-lang="en-US">Specifies the
settings for documents in Microsoft Excel.</paragraph>
+
+<paragraph id="hd_id3154072" role="heading" level="3" xml-lang="en-US">Load
Basic code</paragraph>
+<embed href="text/shared/optionen/01130100.xhp#codetext"/>
<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"/>
-<paragraph xml-lang="en-US" id="hd_id0523200811475727" role="heading"
level="3">Executable code</paragraph>
- <paragraph xml-lang="en-US" id="par_id0523200811475733"
role="paragraph"><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>
- <paragraph xml-lang="en-US" id="hd_id3151211" role="heading" level="3"
>Save original Basic code</paragraph>
- <embed href="text/shared/optionen/01130100.xhp#origtext"/>
- <paragraph xml-lang="en-US" id="hd_id3149202" role="heading" level="2"
>Microsoft PowerPoint 97/2000/XP</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148922"
role="paragraph">Specifies the settings for documents in Microsoft
PowerPoint.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3148451" role="heading" level="3"
>Load Basic code</paragraph>
- <embed href="text/shared/optionen/01130100.xhp#codetext"/>
- <paragraph xml-lang="en-US" id="hd_id3145419" role="heading" level="3"
>Save original Basic code</paragraph>
- <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 xml-lang="en-US" id="par_id3153768" role="paragraph"><link
href="text/shared/optionen/01010200.xhp" name="Setting the default file
format">Setting the default file format</link></paragraph>
- </section>
- </body>
-</helpdocument>
+<embed href="text/shared/optionen/01130100.xhp#executablecode"/>
+
+<paragraph id="hd_id3151211" role="heading" level="3" xml-lang="en-US">Save
original Basic code</paragraph>
+<embed href="text/shared/optionen/01130100.xhp#origtext"/>
+
+<paragraph id="hd_id3149202" role="heading" level="2"
xml-lang="en-US">Microsoft PowerPoint 97/2000/XP</paragraph>
+<paragraph id="par_id3148922" role="paragraph" xml-lang="en-US">Specifies the
settings for documents in Microsoft PowerPoint.</paragraph>
+
+<paragraph id="hd_id3148451" role="heading" level="3" xml-lang="en-US">Load
Basic code</paragraph>
+<embed href="text/shared/optionen/01130100.xhp#codetext"/>
+
+<paragraph id="hd_id3145419" role="heading" level="3" xml-lang="en-US">Save
original Basic code</paragraph>
+<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>
\ No newline at end of file
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
