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
|
<?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="textsharedexplorerdatabasemigrate_macrosxml" indexer="include">
<title xml-lang="en-US" id="tit">Migrate Macros</title>
<filename>/text/sdatabase/migrate_macros.xhp</filename>
</topic>
</meta>
<body>
<section id="migrate_macros">
<bookmark xml-lang="en-US" branch="index" id="bm_id6009095"><bookmark_value>wizards;macros (Base)</bookmark_value>
<bookmark_value>Macro Wizard (Base)</bookmark_value>
<bookmark_value>macros;attaching new (Base)</bookmark_value>
<bookmark_value>migrating macros (Base)</bookmark_value>
</bookmark><comment>MW added 2 index entries</comment>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/prepagepage/PreparePage" id="bm_id0224200911450173" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/summarypage/SummaryPage" id="bm_id0224200911450174" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/migratepage/MigratePage" id="bm_id0224200911450175" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/backuppage/BackupPage" id="bm_id022420091141366" localize="false"/>
<h1 id="hd_id0112200902353472"><link href="text/sdatabase/migrate_macros.xhp">Migrate Macros</link></h1>
<bookmark xml-lang="en-US" branch="hid/.uno:DBMigrateScripts" id="bm_id0224200911384751" localize="false"/>
<paragraph xml-lang="en-US" id="par_id0112200902353466" role="paragraph"><ahelp hid=".">The Database Document Macro Migration Wizard moves existing macros from sub-documents of an old Base file into the new Base file's macro storage area.</ahelp></paragraph>
</section>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/backuppage/browse" id="bm_id022420091141368" localize="false"/>
<paragraph xml-lang="en-US" id="par_id0224200911454780" role="paragraph"><ahelp hid="." visibility="hidden">Choose a location and file name to save the new database file. By default, the new file gets the same name as the old file, while the old file gets renamed with the string "backup" in the name.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/summarypage/textview" id="bm_id0224200911450172" localize="false"/>
<paragraph xml-lang="en-US" id="par_id022420091145472" role="paragraph"><ahelp hid="." visibility="hidden">The list shows all changes that were applied to the database file.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id0112200902353542" role="paragraph">Previously, macros have been allowed to reside only in the text sub-documents of forms and reports. Now macros can also be stored in the Base file itself. This means that macros in Base files can be called now from any of its sub-components: forms, reports, table design, query design, relation design, table data view.</paragraph>
<paragraph xml-lang="en-US" id="par_id0112200903075865" role="paragraph">However, it is technically not possible to store macros both in a Base file and in its sub-documents at the same time. So, if you want to attach some new macros to the Base file, while retaining any existing old macros that were stored in the sub-documents, you must move the existing old macros up to the Base file's macro storage area. </paragraph>
<paragraph xml-lang="en-US" id="par_id0112200903075830" role="paragraph">The Database Document Macro Migration Wizard can move the macros up into the Base file's storage area. You can then examine the macros and edit them as needed. </paragraph>
<paragraph xml-lang="en-US" id="par_id0112200903075951" role="paragraph">For example, it is possible that macros from the sub-documents had the same module names and macro names. After you moved the macros into one common macro storage area, you must edit the macros to make the names unique. The wizard cannot do this.</paragraph>
<paragraph xml-lang="en-US" id="par_id0112200903075915" role="paragraph">The wizard can backup the Base file to another folder of your choice. The wizard changes the original Base file. The backup remains unchanged.</paragraph>
<embed href="text/shared/00/00000001.xhp#back"/>
<embed href="text/shared/00/00000001.xhp#next"/>
<embed href="text/shared/00/00000001.xhp#finish"/>
<embed href="text/shared/00/00000001.xhp#cancel"/>
<section id="relatedtopics">
<paragraph xml-lang="en-US" id="par_id0112200902353554" role="paragraph"><link href="https://wiki.documentfoundation.org/Macros_in_Database_Documents">An in depth explanation by the developers (Wiki).</link></paragraph>
</section>
</body>
</helpdocument>
|
