Home > Excel Help Portal > Using External Data with Excel

<<  (Page 1)  Previous              Next  (Page 3)  >>

Using External Data with Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using external data in
Microsoft Excel.

51. How to export Lotus 123 Linked Files to Excel 2000 This step-by-step article explains how to export Lotus 1-2-3 linked files to Microsoft Excel 2000. A Lotus 1-2-3 worksheet that is opened in Microsoft Excel and contains links to Lotus 1-2-3 source worksheets will maintain these links. These... KB#214009. Keywords: Export, Third-Party, Links, Object, Files

 
52. FRMWRK32.EXE: Updated Generic.xll Template for Excel The sample code provided contains a template that can used for writing 32-bit Microsoft Excel XLLs for Windows. This code demonstrates many of the features of the Microsoft Excel C API. This sample was updated from the Microsoft Excel Developer's... KB#152152. Keywords: Add-In, Download, API, DLL, Export, Startup, Macro, Files, Templates

 
53. How to Run a WordBasic Macro from a Microsoft Excel Macro In Microsoft Excel 2000, you can programmatically create a Visual Basic for Applications macro that uses either Dynamic Data Exchange (DDE) or Automation with Microsoft Word 2000 to run a WordBasic macro. This article demonstrates these methods... KB#213430. Keywords: DDE, Printing, VBA, Macro, Object, Web

 
54. How to Use Automation to Fill a List Box This article shows you how to use Automation to populate a list box with values from a Microsoft Excel worksheet. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using... KB#210145. Keywords: Microsoft Access, OLE, Combo Box, VBA, Object

 
55. How to export an XML Spreadsheet File into Generic XML in Excel 2002 This step-by-step article describes how you can create a generic Extensible Markup Language (XML) file from an XML Spreadsheet file by using an Extensible Stylesheet Language (XSL) template. How to Add a Reference to the Microsoft XML Version... KB#295005. Keywords: Export, XML, Styles, VBA, Macro, Object, Templates, Web

 
56. DAO Error After Installing Visual Basic DAO Application Microsoft Excel 97 may return the following error message when using DAO 3.5, if an application created with Visual Basic 5.0 that uses DAO is installed. Run-time error '429': ActiveX component can't create... KB#189607. Keywords: ActiveX, DAO, Errors, VBA, Error Message, Registry, Window

 
57. How to Use DAO to Create a New Microsoft Excel Workbook In Microsoft Excel, you can use the Data Access Object (DAO) library in a Visual Basic for Applications macro to work with an external database. You can create a new Microsoft Excel workbook with DAO using the instructions included in this... KB#139402. Keywords: DAO, Defined Name, VBA, Macro, Object, Web

 
58. How to import Data from Microsoft SQL Server into Microsoft Excel This step-by-step guide describes how to import data into Microsoft Excel from the Pubs database, a sample database that is included with Microsoft SQL Server. ActiveX Data Objects (ADO) provide access to any type of data source. It is a flat... KB#306125. Keywords: Query, ActiveX, Import Data, OLE, SQL, Errors, Object, VBA, Web, DB

 
59. How to Extract Information from Excel Sheet with DAO The Excel ISAM driver does not dynamically convert... KB#190195. Keywords: DAO, Defined Name, VBA

 
60. New Workbooks Open Repeatedly Starting Excel When you start Microsoft Excel, new workbooks may open... KB#242417. Keywords: Third-Party, Startup, VBA, Files, Web

 
61. How to Create a Microsoft Office Smart Tag List You can create custom smart tags for use in Microsoft Office XP by using Extensible Markup Language (XML). Smart tags created in this way are called Smart Tag Lists. These Smart Tag Lists can only recognize a static list of terms and make use... KB#287698. Keywords: AutoCorrect, DLL, XML, VBA, File Name, Smart Tag, Web

 
62. Cannot Select Named Range from Excel During Mail Merge When you perform a mail merge using a Microsoft Excel 97 worksheet as your data source using the Microsoft Excel Worksheet via Converter (*.xls; *.xlw) option, you will only be able to select the entire worksheet and not a named range from... KB#183417. Keywords: DDE, Format, Files

 
63. Cannot Select Named Range from Excel During Mail Merge When you perform a mail merge using a Microsoft Excel worksheet as your data source and using the Microsoft Excel Worksheet via Converter (*.xls; *.xlw) option, you can select only the entire worksheet and not a named range from... KB#211283. Keywords: DDE, Format, Files

 
64. Overview and History of Excel 2000 Updates This article is a comprehensive list of the service releases, service packs and updates for Microsoft Excel 2000, as of January 2003. How to Determine Which Version of Microsoft Office 2000 Is Installed To determine which version of each Office... KB#269356. Keywords: Add-In, Analysis ToolPak, Dates, Export, Macro, Text Files, HTML, Web

 
65. BUG: StyleSheets Parameter of the OpenXML Method Ignored When Automating Excel When you call the OpenXML method, your code may be interrupted with the Excel Import XML dialog box. User intervention is required for your code to continue. This problem occurs when both of the following conditions are met: You are calling... KB#307230. Keywords: XML, Arrays, Printing, VBA, Macro, Object, Files, HTML

 
66. Cannot Follow Hyperlink to Office Document When you click a hyperlink in a Microsoft Word document or a Microsoft Excel worksheet, either the hyperlink does not go to the correct destination, or nothing... KB#280680. Keywords: DDE, Errors, Registry, Hyperlinks

 
67. How to Use an Excel RTD Server with DCOM Excel 2002 provides a new worksheet function, RTD, that allows you to call a Component Object Model (COM) Automation server for the purpose of retrieving data in real time. This RealTimeData (RTD) server can exist as an ActiveX dynamic-link... KB#285888. Keywords: ActiveX, Formulas, Object, Registry, RTD

 
68. WINHLP32 Causes Invalid Page Fault Running Help When you use Help in the products that are listed at the beginning of this article, and you are running Microsoft Windows 95 or 98, you may receive the following error message: This program has performed an illegal operation and will be shut down.... KB#148117. Keywords: Export, Errors, Registry

 
69. ACC: How to Use the Quit Macro Action or Quit Method This article demonstrates two methods that you can use to close Microsoft Access from a different application. The first method uses the Quit macro action to quit Microsoft Access over a dynamic data exchange (DDE) channel. The second method... KB#100149. Keywords: DDE, Microsoft Access, OLE, Errors, VBA, Macro, Object

 
70. How to Export a Graph from Access to Excel You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a... KB#208327. Keywords: Query, Export, Microsoft Access, Object

 
71. Large Increase in Document File Size After Inserting JPEG In the programs listed at the beginning of this article, if you click the Insert menu, point to Picture, click From File, select a picture file, and click Insert, the following problems may... KB#186369. Keywords: Third-Party, Format, Files

 
72. How to Use OLE Automation to Add Data to Excel Sheet OLE Automation provides a way for Visual FoxPro for Windows to interact with other OLE-compliant applications. Using OLE, the Visual FoxPro program can start a Microsoft Excel session, open a workbook, select a worksheet from the workbook, place... KB#142193. Keywords: OLE, Sales, Printing, Object, Setup, Window

 
73. How to Export a Money Report to an Excel Worksheet This article describes how to export a Microsoft Money report to a Microsoft Excel... KB#302382. Keywords: Export, Import Data, File Name, Text Files

 
74. How to Determine Whether VBA Is Enabled for Office XP Application This article explains how to determine whether Microsoft Visual Basic for Applications (VBA) is installed and enabled for Microsoft Office... KB#285884. Keywords: API, VBA, Object, Registry

 
75. How to Use DAO to Create a New Microsoft Excel Workbook In Microsoft Excel 2000, you can use the Data Access Object (DAO) library in a Microsoft Visual Basic for Applications macro to work with an external database. You can create a new Excel workbook with DAO using the instructions included in... KB#213811. Keywords: DAO, Defined Name, VBA, Macro, Object, Web

 
76. How to Minimize the Size of an XML Spreadsheet File When you save an Excel workbook as an XML Spreadsheet file (*.xml), and the workbook contains large ranges of special formatting, the size of the file may be much larger than the original workbook (*.xls) file size. Note To save an Excel workbook... KB#325091. Keywords: XML, Fonts, Format, Styles

 
77. Objects May Not Be Displayed Correctly When You Use ThirdParty Magnification Software When you use third-party magnification software with the Microsoft Office XP products that are listed at the beginning of this article, objects may not be displayed correctly. Some of the third-party products that are affected include the... KB#316618. Keywords: Third-Party, File Name, Files, Web

 
78. How to Import Contacts from Excel 2000 If you have a list of contacts contained in a Microsoft Excel 2000 spreadsheet, it will not be readily accessible to Outlook 2000 or other programs that may access the Address Book. To overcome this obstacle, you can export and then import the... KB#295664. Keywords: Export, File Name

 
79. RTD Servers Used with Embedded Excel Workbooks May Be Problematic You may experience a number of problems when you host an Excel workbook that contains RealTimeData (RTD) formulas in an OLE or ActiveX Document Container such as Microsoft Internet Explorer. These problems may include the following: Performance... KB#284878. Keywords: ActiveX, OLE, Arrays, Formulas, Internet Explorer, Window, RTD

 
80. How to Find Open Programs That Are DDECapable In Microsoft Excel, you can discover which of your currently open programs are capable of dynamic data exchange (DDE) by using the DDEInitiate method in a Microsoft Visual Basic for Applications macro. You can display a DDE dialog box that lists... KB#213508. Keywords: DDE, VBA, Macro, Web

 
81. Error Creating OLE Automation Object with Microsoft Excel When you use the CreateObject function or the GetObject function in a procedure to create or return a Microsoft Excel OLE Automation object, you may receive one of the following error messages. In Microsoft Excel 97: Run-time error '429':... KB#129252. Keywords: ActiveX, OLE, Errors, Class, Object, VBA, Error Message, Web

 
82. How to Run a WordBasic Macro from an MS Excel Macro In Microsoft Excel for Windows, you can create a Microsoft Excel macro that uses either dynamic data exchange (DDE) or OLE Automation with Microsoft Word to run a WordBasic Macro. The purpose of this article is to demonstrate, by example, how to run... KB#128405. Keywords: DDE, OLE, VBA, Macro, Object, Web

 
83. File Opens Very Slowly When you open or close a workbook in Microsoft Excel, the operation may take longer than... KB#299372. Keywords: ActiveX, Errors, VBA, Object, Files, Web

 
84. Excel Quits Unexpectedly with an Error Message When You Close an Excel Workbook That Contains DDE Links When you close a Microsoft Excel workbook that contains DDE links, you may receive the following error message: Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of... KB#827270. Keywords: DDE, Third-Party, Errors, Error Message, Links, Web

 
85. Cannot Derive Parameter Information When the Parameter Marker Is a Function Argument When you query a database on SQL Server 2000, you may receive the following error message: [Microsoft][ODBC SQL Server Driver]Unable to derive parameter information when parameter marker is a function argument When you click OK , you may receive... KB#821789. Keywords: Query, SQL, Errors, Registry

 
86. How to Add MS Excel 5.0 Dialog Sheet to a Workbook This article describes how to add a Microsoft Excel version 5.0 Dialog sheet to your... KB#154930. Keywords: ActiveX, VBA, UserForm, Web

 
87. How to Use the Quit Method to Quit Access from Another Program This article describes how to close Microsoft Access from a different program using Automation and the Quit... KB#210518. Keywords: Microsoft Access, Errors, VBA, Macro, Object, Web

 
88. How to Import Microsoft Excel File Into Microsoft Access This article explains how to import a Microsoft Excel file into Microsoft Access version 2.0 or 7.0. Microsoft Access can import files from Microsoft Excel version 2.0 through version 7.0. However, Microsoft Access cannot import Microsoft Excel... KB#141228. Keywords: Microsoft Access, Format, Files

 
89. How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook This article describes how to add a Microsoft Excel version 5.0 dialog sheet to your... KB#213255. Keywords: ActiveX, VBA, UserForm, Web

 
90. Running a Microsoft Project Macro from Microsoft Excel This article contains an example to demonstrate how Microsoft Excel can run a Microsoft Project macro using DDE (dynamic data exchange) and Visual Basic for Applications... KB#133710. Keywords: DDE, VBA, Macro, Files, Web

 
91. How to Import an Entire Worksheet from an Excel Workbook This article shows you how to use Visual Basic for Applications to import an entire worksheet from a Microsoft Excel workbook without specifying a... KB#210379. Keywords: Microsoft Access, Errors, VBA, Web

 
92. How To Recover MS Excel File If Unwanted Changes Are Made In Microsoft Excel, if you save unwanted changes to a file, you may be able to recover the original... KB#150368. Keywords: Third-Party, Errors, Error Message, File Name, Files, Macintosh , Save A File

 
93. How to use an Excel Worksheet as a Data Source in FrontPage 2000 This article describes how to use a Microsoft Excel worksheet as a data source in Microsoft FrontPage 2000. Use an Excel Worksheet as a Data Source in FrontPage To use an Excel worksheet as a data source in FrontPage, follow these steps: NOTE:... KB#268948. Keywords: Query, DAO, Files, Web

 
94. How to Determine Which Version of Excel Wrote a Workbook This article demonstrates how to determine the version of Microsoft Excel that wrote a given... KB#225029. Keywords: OLE

 
95. Combo Box Control on a Worksheet Returns to Its Original Value After Refresh A combo box control on a worksheet displays the original value, rather than the new value, after you change the focus from the control to another area of the screen, or after you refresh the display. For example, if a combo box is initialized with... KB#311749. Keywords: ActiveX, Combo Box, File Name, Files, Toolbar, Hyperlinks

 
96. PivotTable Updated Slowly with OLAP Data Source When you pivot or refresh a PivotTable, it takes a long time for Excel to update the PivotTable, and Excel may appear to stop... KB#237469. Keywords: SQL, PivotChart, PivotTables, Parse

 
97. Excel Displays Only First Column in Embedded Worksheet Microsoft Excel displays only the first column in an Auto-Formatted multiple-column worksheet object embedded from a file. This problem occurs when the instance of Microsoft Excel that is opened is subsequently closed. This behavior is exhibited... KB#129793. Keywords: OLE, Object, VBA

 
98. "Out of Virtual Memory" When You Open and Close Many Workbooks with Controls While working in Microsoft Excel, available virtual memory decreases and you may experience one or more of the following symptoms: A slowdown in computer performance Out of Virtual Memory messages Microsoft Excel may stop responding... KB#248180. Keywords: ActiveX, Errors, VBA, Object

 
99. How to Automate Excel 2000 Subtotals Function in Visual FoxPro Microsoft Excel provides a useful function called Subtotals, which you may automate with Microsoft Visual FoxPro. The Subtotals function allows you to choose groups and columns to subtotal. The following example shows how to automate the Excel... KB#265731. Keywords: OLE, Arrays, Object

 
100. Excel Uses Microsoft OLE DB Provider for OLAP Services 8.0 for All OLAP Queries If you configure an Online Analytical Processing (OLAP) query to use the older version of the Microsoft OLE DB Provider for OLAP Services, Excel 2002 continues to use the Microsoft OLE DB Provider for OLAP Services 8.0. This article describes how... KB#286510. Keywords: Query, OLE, Registry, DB

 

<< (Page 1)  Previous              Next  (Page 3) >>