Open Software Solutions

You have a Microsoft Excel 2007 workbook (.XLSX). You want to import data from it into a Microsoft Visual FoxPro (VFP) table using VFP.   Resolution There are a number of ways of accomplishing this task: 1. Export the Excel sheet(s) as comma delimited files (.CSV) and use the IMPORT command or the Import Wizard inside VFP to import the file(s). 2. Write custom VFP OLE automation code to automate Excel and extract the data to VFP. 3. Use the Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) ODBC ... Read more..

MS08-014: Description of the security update for Excel 2007: March 11, 2008View products that this article applies to.Article ID:946974Last Review:March 11, 2008Revision:1.0On This PageINTRODUCTIONMicrosoft has released security bulletin MS08-014. The security bulletin contains all the relevant information about the security update. This information includes file manifest information and deployment options. To view the complete security bulletin, visit one of the following Microsoft Web sites: •Home users:http://www.microsoft.com/protect/computer/updates/bulletins/200803.mspx (http://www.microsoft.com/protect/computer/updates/bulletins/200803.mspx)Skip the details: Download the updates for your home computer or laptop from ... Read more..

SYMPTOMS loadTOCNode(1, \\\'symptoms\\\'); In Microsoft Office Picture Manager, when you export two images of different orientations (one is landscape, the other is portrait), the longest side of each image is reduced to the longest resize resolution that is specified, even if the longest side of the image is not the width (landscape) but, instead the height (portrait) of the image. CAUSE loadTOCNode(1, \\\'cause\\\'); This problem occurs if you choose one of the fixed resolution settings (by using the Export using this ... Read more..

Article ID: 958723 - Last Review: November 5, 2008 - Revision: 1.0Cell borders are printed beyond the page break or specified print area when you print an Excel 2007 worksheet, and you use the B4 (JIS) paper sizeView products that this article applies to.Expand all | Collapse allSYMPTOMS When you print a worksheet that contains cell shading in Microsoft Office Excel 2007, you find that the worksheet is not printed correctly. For example, cell borders extend beyond the page break ... Read more..

SUMMARY loadTOCNode(1, \'summary\'); This step-by-step article shows you how to calculate the number of months between any two dates. To calculate the number of months between any two dates, use one of the following methods. Note that both methods use the following information: EDate = Earlier Date LDate = Later DateNOTE: If you type LDate or EDate directly into this formula instead of into their cell references, you must surround it by quotation marks (for example, "9/7/00"). Round Up loadTOCNode(2, ... Read more..

Error message when you open the Office Assistant in Word 2002 by using Works Suite 2006 on a Windows Vista-based computer: “The Office Assistant requires Microsoft Agent 2.0 or later”View products that this article applies to.Article ID:930203Last Review:March 20, 2007Revision:1.2SYMPTOMSWhen you open the Office Assistant in Microsoft Word 2002 by using Microsoft Works Suite 2006 on a Windows Vista-based computer, you receive the following error message:The Office Assistant requires Microsoft Agent 2.0 or later.Back to the topCAUSEThis ... Read more..

How to configure SharePoint Server 2007 and Excel Services for Kerberos authenticationView products that this article applies to.Article ID:953130Last Review:July 2, 2008Revision:1.0On This PageINTRODUCTIONThis article describes how to configure a server that is running Windows Server 2003, Microsoft Office SharePoint Server 2007, and Excel Services for Kerberos authentication.Back to the topMORE INFORMATIONFollow these steps in the order in which they are presented to configure the Kerberos protocol on SharePoint Server 2007 and on Excel Services.Back to the topConfigure SharePoint Server ... Read more..

The Analysis ToolPak is a Microsoft Office Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. Click the Microsoft Office Button, and then click Excel Options. Click Add-Ins, and then in the Manage box, select Excel Add-ins. Click Go. In the Add-Ins available ... Read more..

Article ID: 957253 - Last Review: November 12, 2008 - Revision: 1.0Description of the update for Microsoft Office Script Editor Help: November 11, 2008View products that this article applies to.On This PageExpand all | Collapse allINTRODUCTIONMicrosoft has released updated Help (HxS) files for Microsoft Office Script Editor for 2007 Microsoft Office system. This update contains the latest revisions and additions to Office Script Editor Help and Office Script Editor Developer Help.Back to the topMORE INFORMATIONUpdate information The updates for Microsoft ... Read more..

The changes in the TOC and PageRef fields do not appear when you compare Word 2007 documentsView products that this article applies to.Article ID:954540Last Review:July 17, 2008Revision:1.0SYMPTOMSYou update some page values in a Microsoft Office Word 2007 document. When you compare the revised document to the original document, the changes in the TOC and PageRef fields do not appear.RESOLUTIONImportant This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might ... Read more..

Description of the 2007 Office system hotfix package: June 10, 2008View products that this article applies to.Article ID:953474Last Review:July 24, 2008Revision:1.0On This PageSUMMARYThis article describes the 2007 Microsoft Office system issue that is fixed in the hotfix package that is dated June 10, 2008.This article describes the following items about the hotfix package:•The issues that the hotfix package fixes.•The prerequisites for installing the hotfix package.•Whether you must restart the computer after you install the hotfix package.•Whether the hotfix package is ... Read more..

INTRODUCTION loadTOCNode(1, \\\'summary\\\'); Microsoft has added the new Office Open XML Formats to the following 2007 Microsoft Office programs:   Microsoft Office Excel 2007   Microsoft Office PowerPoint 2007   Microsoft Office Word 2007 A compatibility pack is available to make sure that you can open and save Office Open XML Formats in earlier versions of Microsoft Office. You can install the compatibility pack on a computer that is running Microsoft Office 2003 programs, Microsoft Office XP programs, or Microsoft Office 2000 programs. When you install the ... Read more..

SUMMARY loadTOCNode(1, \'summary\'); This article describes how to use the LOOKUP function in a Microsoft Excel worksheet. MORE INFORMATION loadTOCNode(1, \'moreinformation\'); The LOOKUP function returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: vector and array. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value, and then returns a value from the same position in a second one-row or ... Read more..

Description of the Word 2007 hotfix package: May 27, 2008View products that this article applies to.Article ID:951997Last Review:June 14, 2008Revision:1.1On This PageSUMMARYThis article describes the Microsoft Office Word 2007 issue that is fixed in the hotfix package that is dated May 27, 2008.This article describes the following items about the hotfix package:•The issues that the hotfix package fixes.•The prerequisites for installing the hotfix package.•Whether you must restart the computer after you install the hotfix package.•Whether the hotfix package is replaced ... Read more..

How to implement Forms-based authentication for Office SharePoint Server 2007 by using SQL ServerView products that this article applies to.Article ID:952170Last Review:June 17, 2008Revision:1.0INTRODUCTIONThis article describes how to implement Forms-based authentication for Microsoft Office SharePoint Server 2007 by using Microsoft SQL Server that is installed on the same computer.MORE INFORMATIONTo implement Forms-based authentication for Office SharePoint Server 2007 by using an instance of SQL Server that is installed on the same computer, follow these steps:1. Create an Aspnetdb database to use ... Read more..

Article ID: 956137 - Last Review: November 25, 2008 - Revision: 1.0Description of the Office Migration Planning Manager (OMPM) hotfix package (Offscan.exe): October 28, 2008Hotfix Download AvailableView and request hotfix downloadsView products that this article applies to.On This PageExpand all | Collapse allSUMMARYThis article describes the Office Migration Planning Manager issues that are fixed in the hotfix package that is dated October 28, 2008.This article describes the following items about the hotfix package:The issues that the hotfix package fixes.The prerequisites ... Read more..

Description of the Word 2007 hotfix package: June 10, 2008View products that this article applies to.Article ID:953924Last Review:July 8, 2008Revision:1.0On This PageSUMMARYThis article describes the Microsoft Office Word 2007 issues that are fixed in the hotfix package that is dated June 10, 2008.This article describes the following items about the hotfix:•The issues that the hotfix fixes.•The prerequisites for installing the hotfix.•Whether you must restart the computer after you install the hotfix.•Whether the hotfix is replaced by any other hotfix.•Whether you ... Read more..

Detection and deployment guidance for the May 13, 2008 security releaseView products that this article applies to.Article ID:952726Last Review:May 13, 2008Revision:1.0On This PageINTRODUCTIONAs part of an ongoing commitment to provide detection tools and deployment recommendations for security updates, Microsoft is delivering this detection and deployment guidance for all updates that are released during a Microsoft Security Response Center (MSRC) release cycle. This guidance contains recommendations that are based on the kinds of scenarios that may exist in various Microsoft operating ... Read more..

Article ID: 960502 - Last Review: January 26, 2009 - Revision: 4.0Description of the 2007 Office system hotfix package (Offfiltx.msp, Visfilter.msp): December 16, 2008Hotfix Download AvailableView and request hotfix downloadsView products that this article applies to.On This PageExpand all | Collapse allSUMMARYThis article describes the 2007 Office system issue that is fixed in the 2007 Office system hotfix package that is dated December 16, 2008.This article describes the following items about the hotfix package:The issues that the hotfix package fixes.The ... Read more..

An Excel 2007 workbook is not saved as expected to a document library on a Windows SharePoint Services siteView products that this article applies to.Article ID:928985Last Review:October 15, 2007Revision:1.2SYMPTOMSConsider the following scenario. You try to save a Microsoft Office Excel 2007 workbook to a document library on a Microsoft Windows SharePoint Services site. The workbook is not saved as expected. If you make a change in the workbook and then try the save it again, the workbook appears to ... Read more..