Home > Excel Help Portal > Using External Data with Excel

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

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.

1. Office 2000, my experience in installing - Progress report
2. How to transfer Data to an Excel Workbook by Using Visual Basic .NET
3. Clip Gallery General Troubleshooting Tips Part 1 of 2
4. Methods for Transferring Data to Excel from Visual Basic
5. How to create a Smart Tag DLL in Visual Basic for Use in Office XP
6. How to Dismiss a Dialog Box Displayed by an Office Application with Visual Basic
7. ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks
8. How to develop DatabaseDriven Smart Tags for Office by Using Visual Basic for Windows
9. How to configure Office applications for automation from a COM+/MTS package
10. How to query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET
11. How to import Data into SQL Server from Excel
12. Using a field alias in Query does not work with some thirdparty databases
13. How to retrieve Metadata from Excel by Using the GetOleDbSchemaTable Method in Visual Basic .NET
14. General Information about Microsoft Office Encryption
15. How to transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET
16. How to activate a Perpetual License in Office XP Programs
17. Information about how to extract Office file formats and schemas
18. How to export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel
19. How to transfer Data to Excel by Using SQL Server Data Transformation Services
20. How to automate Excel Text to Speech in Another Office Program
21. How to get Windows Status Information from Windows API in Excel 2000
22. ADO Inserts Data into Wrong Columns in Excel
23. GetObject and CreateObject Behavior of Office Automation Servers
24. How to Obtain the Window Handle for an Office Automation Server
25. How to Prevent File Corruption
26. How to Retrieve a Table from Access into Excel Using DAO
27. RTD Server Does Not Send Update Notifications to Multiple Excel Instances
28. How and Why Unique Identifiers Are Created in Office Documents
29. How to remove Template Listings in Excel
30. How to use the Undo Feature with Inserted Objects in Office XP Programs
31. How to remove Template Listings in Excel
32. How to Use DAO to Append the Records in Two Tables
33. How to Determine the Path for an Office Application
34. How to Append an Excel Worksheet to a Database Using DAO
35. How to clear the Most Recently Used List in Office Programs
36. How to Obtain BuiltIn Constant Values for an Office Application
37. Error Messages in Programs That Use Word 2000 with Norton AntiVirus Installed
38. How to Open XML Files in Excel
39. How to configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002
40. Sample Macro to Import Data with More Than 256 Fields or Columns
41. How to call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office
42. You may receive "The command you selected is not available from this shortcut" error message when you use the Open dialog box or the Save dialog box in Excel 2003
43. How to Use ADO to Return Data to a ListBox or ComboBox
44. How to Mark an Automation AddIn Function as Volatile
45. How to Reduce the Chances of Macro Virus Infection
46. How to Minimize Metadata in Microsoft Office Documents
47. How to Use DAO in Excel Without Referencing DAO Library
48. How to use an Excel Data Source for Mail Merge in Word 2000
49. How to Drag Data from Microsoft Excel to a Microsoft Access Database
50. How to Use Microsoft Excel Data Source for Word Mail Merge

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