1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir<helpdocument version="1.0"> 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir*********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir<topic id="textsharedguidems_userxml" indexer="include"> 36*cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Using Microsoft Office and $[officename]</title> 37*cdf0e10cSrcweir<filename>/text/shared/guide/ms_user.xhp</filename> 38*cdf0e10cSrcweir</topic> 39*cdf0e10cSrcweir</meta> 40*cdf0e10cSrcweir<body> 41*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150789"><bookmark_value>Office;Microsoft Office and $[officename]</bookmark_value> 42*cdf0e10cSrcweir<bookmark_value>Microsoft Office;new users information</bookmark_value> 43*cdf0e10cSrcweir<bookmark_value>opening;Microsoft Office files</bookmark_value> 44*cdf0e10cSrcweir<bookmark_value>saving;in Microsoft Office file format</bookmark_value> 45*cdf0e10cSrcweir<bookmark_value>macros; in MS Office documents</bookmark_value> 46*cdf0e10cSrcweir</bookmark> 47*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3150789" xml-lang="en-US" level="1" l10n="U" oldref="30"><variable id="ms_user"><link href="text/shared/guide/ms_user.xhp" name="Using Microsoft Office and $[officename]">Using Microsoft Office and $[officename]</link> 48*cdf0e10cSrcweir</variable></paragraph> 49*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152801" xml-lang="en-US" l10n="CHG" oldref="1">$[officename] can open and save documents in the Microsoft Office file formats. Microsoft Office Open XML formats can be read, but not saved.</paragraph> 50*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145345" xml-lang="en-US" level="2" l10n="U" oldref="2">Opening a Microsoft Office File</paragraph> 51*cdf0e10cSrcweir<list type="ordered"> 52*cdf0e10cSrcweir<listitem> 53*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3147008" xml-lang="en-US" l10n="U" oldref="3">Choose <emph>File - Open</emph>. Select a Microsoft Office file in the $[officename] file open dialog.</paragraph> 54*cdf0e10cSrcweir</listitem> 55*cdf0e10cSrcweir</list> 56*cdf0e10cSrcweir<table id="tbl_id3147653"> 57*cdf0e10cSrcweir<tablerow> 58*cdf0e10cSrcweir<tablecell> 59*cdf0e10cSrcweir<paragraph role="tablehead" id="par_id3156346" xml-lang="en-US" l10n="U" oldref="4">MS Office file...</paragraph> 60*cdf0e10cSrcweir</tablecell> 61*cdf0e10cSrcweir<tablecell> 62*cdf0e10cSrcweir<paragraph role="tablehead" id="par_id3155342" xml-lang="en-US" l10n="U" oldref="5">...will open in $[officename] module</paragraph> 63*cdf0e10cSrcweir</tablecell> 64*cdf0e10cSrcweir</tablerow> 65*cdf0e10cSrcweir<tablerow> 66*cdf0e10cSrcweir<tablecell> 67*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3153543" xml-lang="en-US" l10n="U" oldref="6">MS Word, *.doc, *.docx</paragraph> 68*cdf0e10cSrcweir</tablecell> 69*cdf0e10cSrcweir<tablecell> 70*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3147620" xml-lang="en-US" l10n="U" oldref="7">$[officename] Writer</paragraph> 71*cdf0e10cSrcweir</tablecell> 72*cdf0e10cSrcweir</tablerow> 73*cdf0e10cSrcweir<tablerow> 74*cdf0e10cSrcweir<tablecell> 75*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3154898" xml-lang="en-US" l10n="U" oldref="8">MS Excel, *.xls, *.xlsx</paragraph> 76*cdf0e10cSrcweir</tablecell> 77*cdf0e10cSrcweir<tablecell> 78*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3149580" xml-lang="en-US" l10n="U" oldref="9">$[officename] Calc</paragraph> 79*cdf0e10cSrcweir</tablecell> 80*cdf0e10cSrcweir</tablerow> 81*cdf0e10cSrcweir<tablerow> 82*cdf0e10cSrcweir<tablecell> 83*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3147574" xml-lang="en-US" l10n="U" oldref="10">MS PowerPoint, *.ppt, *.pps, *.pptx</paragraph> 84*cdf0e10cSrcweir</tablecell> 85*cdf0e10cSrcweir<tablecell> 86*cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id3153626" xml-lang="en-US" l10n="U" oldref="11">$[officename] Impress</paragraph> 87*cdf0e10cSrcweir</tablecell> 88*cdf0e10cSrcweir</tablerow> 89*cdf0e10cSrcweir</table> 90*cdf0e10cSrcweir 91*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3147303" xml-lang="en-US" level="2" l10n="U" oldref="12">Saving as a Microsoft Office File</paragraph> 92*cdf0e10cSrcweir<list type="ordered"> 93*cdf0e10cSrcweir<listitem> 94*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3145068" xml-lang="en-US" l10n="U" oldref="13">Choose <emph>File - Save As</emph>.</paragraph> 95*cdf0e10cSrcweir</listitem> 96*cdf0e10cSrcweir<listitem> 97*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3153379" xml-lang="en-US" l10n="U" oldref="14">In the <emph>File type</emph> box, select a Microsoft Office file format.</paragraph> 98*cdf0e10cSrcweir</listitem> 99*cdf0e10cSrcweir</list> 100*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="2" l10n="CHG" oldref="15">Saving Documents by Default in Microsoft Office Formats</paragraph> 101*cdf0e10cSrcweir<list type="ordered"> 102*cdf0e10cSrcweir<listitem> 103*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3144760" xml-lang="en-US" l10n="U" oldref="16">Choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01010200.xhp" name="Load/Save - General">Load/Save - General</link></emph>.</paragraph> 104*cdf0e10cSrcweir</listitem> 105*cdf0e10cSrcweir<listitem> 106*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3148453" xml-lang="en-US" l10n="U" oldref="17">In the <emph>Default file format and ODF settings</emph> area, first select a document type, then select the file type for saving.</paragraph> 107*cdf0e10cSrcweir</listitem> 108*cdf0e10cSrcweir</list> 109*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149807" xml-lang="en-US" l10n="U" oldref="18">From now on, if you save a document, the <emph>File type </emph>will be set according to your choice. Of course, you still can select another file type in the file save dialog.</paragraph> 110*cdf0e10cSrcweir<switch select="sys"> 111*cdf0e10cSrcweir<case select="WIN"> 112*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156423" xml-lang="en-US" level="2" l10n="CHG" oldref="19">Opening Microsoft Office Files by Default</paragraph> 113*cdf0e10cSrcweir<embed href="text/shared/guide/ms_doctypes.xhp#ms_extensions"/> 114*cdf0e10cSrcweir</case> 115*cdf0e10cSrcweir</switch> 116*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153092" xml-lang="en-US" level="2" l10n="CHG" oldref="20">Converting Many Microsoft Office Files into OpenDocument Format</paragraph> 117*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146986" xml-lang="en-US" l10n="CHG" oldref="21">The <emph>Document Converter Wizard</emph> will copy and convert all Microsoft Office files in a folder into $[officename] documents in the OpenDocument file format. You can specify the folder to be read, and the folder where the converted files are to be saved.</paragraph> 118*cdf0e10cSrcweir<list type="ordered"> 119*cdf0e10cSrcweir<listitem> 120*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3150486" xml-lang="en-US" l10n="U" oldref="22">Choose <link href="text/shared/autopi/01130000.xhp" name="File - AutoPilot - Document Converter"><emph>File - Wizards - Document Converter</emph></link> to start the wizard.</paragraph> 121*cdf0e10cSrcweir</listitem> 122*cdf0e10cSrcweir</list> 123*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3154319" xml-lang="en-US" level="2" l10n="U" oldref="23">Macros in Microsoft Office and $[officename]</paragraph> 124*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154921" xml-lang="en-US" l10n="U" oldref="24">With a few exceptions, Microsoft Office and $[officename] cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and $[officename] uses Basic code based on the $[officename] API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different.</paragraph> 125*cdf0e10cSrcweir<paragraph role="note" id="par_id0804200804173539" xml-lang="en-US" l10n="NEW">The most recent versions of %PRODUCTNAME can run some Excel Visual Basic scripts if you enable this feature at <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Load/Save - VBA Properties</item>.</paragraph> 126*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152577" xml-lang="en-US" l10n="U" oldref="25">If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. $[officename] can load the macros that are contained within Microsoft Office files and you can then view and edit the macro code in the $[officename] <link href="text/shared/main0600.xhp" name="Basic IDE">Basic IDE</link> editor.</paragraph> 127*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="3" l10n="U" oldref="26">You can choose to preserve or delete VBA macros</paragraph> 128*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153144" xml-lang="en-US" l10n="U" oldref="27">Open a Microsoft Office document that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do not edit the macros. Save the document as a Microsoft Office file type. Open the file in Microsoft Office, and the VBA macros will run as before.</paragraph> 129*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="28">You may delete the VBA macros from the Microsoft Office file on loading or on saving.</paragraph> 130*cdf0e10cSrcweir<list type="ordered"> 131*cdf0e10cSrcweir<listitem> 132*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3155366" xml-lang="en-US" l10n="U" oldref="29">Choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01130100.xhp" name="Load/Save - VBA Properties">Load/Save - VBA Properties</link></emph> to set the VBA macro handling of $[officename].</paragraph> 133*cdf0e10cSrcweir</listitem> 134*cdf0e10cSrcweir</list> 135*cdf0e10cSrcweir<embed href="text/shared/00/00000004.xhp#related"/> 136*cdf0e10cSrcweir<embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/> 137*cdf0e10cSrcweir<embed href="text/shared/guide/doc_open.xhp#doc_open"/> 138*cdf0e10cSrcweir<embed href="text/shared/guide/import_ms.xhp#import_ms"/> 139*cdf0e10cSrcweir<embed href="text/shared/guide/export_ms.xhp#export_ms"/> 140*cdf0e10cSrcweir<switch select="sys"> 141*cdf0e10cSrcweir<case select="WIN"><embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/></case> 142*cdf0e10cSrcweir</switch> 143*cdf0e10cSrcweir</body> 144*cdf0e10cSrcweir</helpdocument> 145