diff options
Diffstat (limited to 'source/text/sbasic/shared')
-rw-r--r-- | source/text/sbasic/shared/03103350.xhp | 71 | ||||
-rw-r--r-- | source/text/sbasic/shared/main0601.xhp | 38 | ||||
-rw-r--r-- | source/text/sbasic/shared/vbasupport.xhp | 55 |
3 files changed, 146 insertions, 18 deletions
diff --git a/source/text/sbasic/shared/03103350.xhp b/source/text/sbasic/shared/03103350.xhp new file mode 100644 index 0000000000..6cd1eb4262 --- /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 45324adca4..e9e9e50160 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 0000000000..694afd33c8 --- /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 |