summaryrefslogtreecommitdiff
path: root/source/text/sbasic/shared/vbasupport.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'source/text/sbasic/shared/vbasupport.xhp')
-rw-r--r--source/text/sbasic/shared/vbasupport.xhp55
1 files changed, 55 insertions, 0 deletions
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