Home > Excel Help Portal > Programming Excel

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

Programming Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to program
Microsoft Excel using VBA.

51. How to Create a Visual Basic Automation Addin for Excel Worksheet Functions
52. ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks
53. How to develop DatabaseDriven Smart Tags for Office by Using Visual Basic for Windows
54. How to Work with Random Access Files
55. Excel FAQ - Macros
56. How to configure Office applications for automation from a COM+/MTS package
57. Extraction of a Group of Digits and Dashes, from postings by Harlan Grove
58. How to Dynamically Create Excel 5.0 Charts in OLE 2.0 Control
59. How to Transfer Data from an ADO Recordset to Excel with Automation
60. How to Create a RealTimeData Server for Excel
61. Quick Chart VBA Examples
62. Number Conversions
63. Build TOC Another Approach
64. Internet Explorer Cannot Open an Excel AddIn (*.xla) File
65. How to Identify and Remove PLDT/CAR/SGV Macro Viruses
66. How to Use Visual Basic or ASP to Create an XML Spreadsheet for Excel 2002
67. Shapes
68. You are prompted to grant permission for ActiveX Controls when you open an Office 2003 document
69. Excel 2000 SR1 Macro Modification Security Update
70. How to configure Office applications to run under a specific user account
71. How to query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET
72. How to convert Text to Numbers in Excel 2003
73. How to import Data into SQL Server from Excel
74. How to use the Forms Controls on a Worksheet in Excel 2000
75. Recording and customizing a macro
76. Event Macro to Add Path and Filename to Excel Header
77. How to use the Forms Controls on a Worksheet in Excel 2002
78. How to handle events for Excel 2003 by using Visual Basic .NET
79. How to Programmatically Perform a Web Query
80. How to Return Data from a Dialog Box to a Worksheet
81. How to handle Events for Excel by Using Visual Basic .NET
82. How to Create a Monthly Calendar
83. Headings for Columns, and Page Numbering
84. How to retrieve Metadata from Excel by Using the GetOleDbSchemaTable Method in Visual Basic .NET
85. How to eliminate redundant data in an Excel list
86. How to Return Data from a Dialog Box to a Worksheet
87. HELP in and for Excel
88. Barhopper -- fixup for Restored Toolbars (also List of Menu Items)
89. How to Display a Custom Office Assistant Balloon
90. How to Create a Monthly Calendar
91. How to transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET
92. How to Programmatically Perform a Web Query
93. How to Use Looping Structures in Visual Basic for Applications
94. Quicken Utilties for Excel
95. How to reset Personal Menus in Office XP and Office 2000 Programs
96. Summary of Methods to Recover Data from Corrupted Files
97. How to troubleshoot Custom Smart Tags in Office
98. How to convert Text to Numbers in Microsoft Excel 2002
99. How to use Visual Basic .NET for Binding for Office Automation Servers
100. Running Subroutines and Macros from Visual Basic

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