Excel 2002 (Excel XP) articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2002 (Excel XP) starts with letter H that have been released. The list is daily updated.

219905 How to dynamically add and run a VBA macro from Visual Basic Q219905 KB219905 January 25, 2021
211922 How to modify the number of undo levels in Excel Q211922 KB211922 November 20, 2020
830258 How to create a "Masked Password" dialog box in Office programs by using Visual Basic for Applications Q830258 KB830258 September 29, 2020
214328 Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel Q214328 KB214328 August 20, 2020
306572 How to query and display excel data by using ASP.NET, ADO.NET, and Visual C# .NET Q306572 KB306572 June 10, 2019
291304 How to select ranges using Visual Basic for Applications (novice examples) Q291304 KB291304 June 10, 2019
291308 How to select cells/ranges by using Visual Basic procedures in Excel Q291308 KB291308 May 28, 2019
243058 How to use the WebBrowser control to open an Office document Q243058 KB243058 May 28, 2019
833402 How to convert Excel column numbers into alphabetical characters Q833402 KB833402 May 27, 2019
304643 How to use the WebBrowser control in Visual Basic to open an Office document Q304643 KB304643 May 27, 2019
302096 How to automate Excel by using Visual C# to fill or to obtain data in a range by using arrays Q302096 KB302096 May 27, 2019
302094 How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays Q302094 KB302094 May 27, 2019
302084 How to automate Microsoft Excel from Microsoft Visual C#.NET Q302084 KB302084 May 27, 2019
291320 How to use macro examples to delete duplicate items in a list in Excel Q291320 KB291320 May 27, 2019
271513 How to troubleshoot errors when you save Excel workbooks Q271513 KB271513 May 27, 2019
234788 How to find the installation path of an Office application Q234788 KB234788 May 27, 2019
219151 How to automate Microsoft Excel from Visual Basic Q219151 KB219151 May 27, 2019
216686 How to automate Excel from C++ without using MFC or #import Q216686 KB216686 May 27, 2019
211736 How to display a progress bar with a user form in Excel Q211736 KB211736 May 27, 2019
89794 How to use Visual Basic for Applications to count the occurrences of a character in a selection in Excel Q89794 KB89794 May 27, 2019
826922 How to prevent files from opening automatically in Excel Q826922 KB826922 May 9, 2019
213612 How to run a macro when certain cells change in Excel Q213612 KB213612 January 8, 2019
213428 How to suppress "Save Changes" prompt when you close a workbook in Excel Q213428 KB213428 December 7, 2018
324861 How to find data in an Excel table Q324861 KB324861 May 14, 2018
273711 How to obtain the latest Excel Viewer Q273711 KB273711 April 30, 2018
285888 How to use an Excel RTD server with DCOM Q285888 KB285888 April 22, 2018
239930 How to obtain built-in constant values for an Office application Q239930 KB239930 April 22, 2018
192348 How to automate Excel and then know the user closed it Q192348 KB192348 April 22, 2018
329820 How to use Office programs with the Norton AntiVirus Office plug-in Q329820 KB329820 April 21, 2018
826924 How to apply different passwords or permissions to separate ranges in workbooks in Excel Q826924 KB826924 April 20, 2018
820204 How to change from absolute to relative or mixed references in a formula in Excel Q820204 KB820204 April 20, 2018
325091 How to minimize the size of an XML Spreadsheet file in Excel Q325091 KB325091 April 20, 2018
308983 How to specify trusted sources for Digital Certificates in Excel, in PowerPoint, in and Word Q308983 KB308983 April 20, 2018
289508 How to view error signatures if an Office program experiences a serious error and quits Q289508 KB289508 April 20, 2018
289262 How to use the AutoRepublish feature in Excel Q289262 KB289262 April 20, 2018
213616 How to use a macro to apply cell shading format to every other row in a selected range in Excel Q213616 KB213616 April 20, 2018
213460 How to programmatically print all embedded charts on a worksheet Q213460 KB213460 April 20, 2018
213445 How to use the OnEntry macro to create a running total in a cell comment in Excel Q213445 KB213445 April 20, 2018
840817 How to extract information from Office files by using Office file formats and schemas Q840817 KB840817 April 19, 2018
826214 How to customize the My Places bar in both the Open and the Save As dialog boxes in Office Q826214 KB826214 April 18, 2018
317719 How To Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel Q317719 KB317719 April 18, 2018
316126 How to use Visual C# to automate a running instance of an Office program Q316126 KB316126 April 18, 2018
315731 How to retrieve the names of macros from an Excel workbook by using Visual Basic 6.0 Q315731 KB315731 April 18, 2018
311546 How to embed and automate an Excel worksheet by using MFC and Visual C++ 2005 or Visual C++ .NET Q311546 KB311546 April 18, 2018
308407 How to automate Excel from MFC and Visual C++ 2005 or Visual C++ .NET to fill or obtain data in a range using arrays Q308407 KB308407 April 18, 2018
307029 How to transfer XML data to Microsoft Excel 2002 or Microsoft Excel 2003 by using Visual C# Q307029 KB307029 April 18, 2018
302901 How to build an Office COM add-in by using Visual C# .NET Q302901 KB302901 April 18, 2018
288130 How to use ASP to build spreadsheet XML for client-side display Q288130 KB288130 April 18, 2018
285891 How to use Visual Basic or ASP to create an XML spreadsheet for Excel 2002 and Excel 2003 Q285891 KB285891 April 18, 2018
270844 How to create an Excel histogram by using Automation and Analysis ToolPak Q270844 KB270844 April 18, 2018
258511 How to obtain the window handle for an Office Automation server Q258511 KB258511 April 18, 2018
242243 How To embed and automate Office documents with Visual Basic Q242243 KB242243 April 18, 2018
213810 How to determine how many pages will be printed in Excel Q213810 KB213810 April 18, 2018
199691 How to automate using Visual C++ to save Excel worksheet as HTML file Q199691 KB199691 April 18, 2018
190985 How to get IDispatch of an Excel or Word document from an OCX Q190985 KB190985 April 18, 2018
184663 How to embed and automate a Microsoft Excel worksheet with MFC Q184663 KB184663 April 18, 2018
895456 How to change the product key for Office XP, for Office 2003, and for the 2007 Office system Q895456 KB895456 April 17, 2018
830287 How to create a dynamic defined range in an Excel worksheet Q830287 KB830287 April 17, 2018
826921 How to control the startup message about updating linked workbooks in Excel Q826921 KB826921 April 17, 2018
825012 How formula calculations are performed in Excel Q825012 KB825012 April 17, 2018
819964 How to convert a single column of addresses to a CSV text file in Excel Q819964 KB819964 April 17, 2018
816644 How to send a range of cells in an e-mail message by using Visual Basic for Applications in Excel Q816644 KB816644 April 17, 2018
812386 How to sort worksheets alphanumerically in a workbook in Excel Q812386 KB812386 April 17, 2018
318118 How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet Q318118 KB318118 April 17, 2018
306023 How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET Q306023 KB306023 April 17, 2018
304662 How to use the WebBrowser control to open Office documents in Visual C# 2005 or in Visual C# .NET Q304662 KB304662 April 17, 2018
299036 How to loop through a list of data on a worksheet by using macros in Excel Q299036 KB299036 April 17, 2018
291363 How to use the "Insert Options" button in Excel Q291363 KB291363 April 17, 2018
291321 How to programmatically reset a workbook to default styles Q291321 KB291321 April 17, 2018
291073 How to use the forms controls on a worksheet in Excel Q291073 KB291073 April 17, 2018
290142 How to open documents from FTP site and save documents to FTP site with Office programs. Q290142 KB290142 April 17, 2018
289577 How to make Paste Options button disappear after you paste in Excel Q289577 KB289577 April 17, 2018
287392 How to programmatically turn off the Clipboard warning message Q287392 KB287392 April 17, 2018
285339 How to create a RealTimeData server for Excel Q285339 KB285339 April 17, 2018
267982 How to use a logical AND or OR in a SUM+IF statement in Excel Q267982 KB267982 April 17, 2018
266691 How to sum and format a range of hours, minutes, or seconds in Excel Q266691 KB266691 April 17, 2018
246335 How to transfer data from an ADO Recordset to Excel with automation Q246335 KB246335 April 17, 2018
234774 How to automate Excel from an HTML Web page by using JScript Q234774 KB234774 April 17, 2018
214395 How Excel determines the current mode of calculation Q214395 KB214395 April 17, 2018
214024 How to convert multiple rows and columns to columns and rows in Excel Q214024 KB214024 April 17, 2018
213933 How to use the INDIRECT function to create references in Excel Q213933 KB213933 April 17, 2018
213907 How to calculate compound interest for an intra-year period in Excel Q213907 KB213907 April 17, 2018
213750 How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel Q213750 KB213750 April 17, 2018
213630 How to use the IF THEN ELSE statement and the SELECT CASE statement in examples written in Visual Basic for Excel Q213630 KB213630 April 17, 2018
213610 How to delete every other row on an Excel worksheet Q213610 KB213610 April 17, 2018
213367 How to compare data in two columns to find duplicates in Excel Q213367 KB213367 April 17, 2018
183446 How to use defined names to automatically update a chart range in Excel Q183446 KB183446 April 17, 2018
832286 How to save the addresses from a Word mail-merge label document to Excel Q832286 KB832286 April 16, 2018
826208 How to edit the Windows registry to clear the list of most recently used files in Office Q826208 KB826208 April 16, 2018
291300 How to delete cells by using a "For Each...Next" loop Q291300 KB291300 April 16, 2018
291050 How to use the IF worksheet function to suppress the #DIV/0! error value in Excel Q291050 KB291050 April 16, 2018
289270 How to apply different passwords or permissions to separate ranges in worksheets in Excel Q289270 KB289270 April 16, 2018
289150 How to set up and use the RTD function in Excel Q289150 KB289150 April 16, 2018
289146 How to turn off Function Argument ToolTips in Excel Q289146 KB289146 April 16, 2018
288958 How to remove smart tags from a workbook in Excel Q288958 KB288958 April 16, 2018
288852 How to use Draw Border tools and Draw Border Grid tools to apply and remove cell borders in Excel Q288852 KB288852 April 16, 2018
282856 How to create and use two-input data tables in Microsoft Excel Q282856 KB282856 April 16, 2018
282135 How to display more digits in trendline equation coefficients in Excel Q282135 KB282135 April 16, 2018
269860 How to use shared workbooks with different versions of Excel Q269860 KB269860 April 16, 2018
254791 How to manage multiple windows in Excel Q254791 KB254791 April 16, 2018
245104 How to calculate ages before 1/1/1900 in Excel Q245104 KB245104 April 16, 2018
214391 How Excel works with two-digit year numbers Q214391 KB214391 April 16, 2018
213646 How to use the left, right, mid, and len functions in Visual Basic for Applications in Excel Q213646 KB213646 April 16, 2018
213641 How to programmatically save a file to a network drive in Excel Q213641 KB213641 April 16, 2018
213609 How to hide sheets and use xlVeryHidden constant in a macro Q213609 KB213609 April 16, 2018
213566 How to create application-level event handlers in Excel Q213566 KB213566 April 16, 2018
213389 How to programmatically copy all range names in Excel Q213389 KB213389 April 16, 2018
213257 How to set page setup attributes for more than one sheet Q213257 KB213257 April 16, 2018
182189 How to create a conditional format to hide errors in Excel Q182189 KB182189 April 16, 2018
827710 How to control the size of a UserForm in Excel Q827710 KB827710 April 12, 2018
843144 How to use variables in Excel sub-procedures in Visual Basic for Applications Q843144 KB843144 July 11, 2017
264372 How to control and understand settings in the Format Cells dialog box in Excel Q264372 KB264372 June 14, 2017
321686 How to import data from Excel to SQL Server Q321686 KB321686 April 26, 2017
914200 How to convert European currencies programmatically by using the Excel MSoEuro component and how to use the Euro Currency Tools add-in Q914200 KB914200 March 29, 2017
898513 How to insert or paste an Excel 2003 worksheet or an Excel 2002 worksheet to a drawing in Visio Q898513 KB898513 March 29, 2017
162059 How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer Q162059 KB162059 August 15, 2016
924074 How to open new file formats in earlier versions of Microsoft Office Q924074 KB924074 September 23, 2015
928134 Headers and footers are unreadable when you open an Excel 2003 or Excel 2002 Web page file in a different language version of Excel Q928134 KB928134 January 15, 2015
243394 HOWTO: Use MFC to Copy a DAO Recordset to Excel with Automation Q243394 KB243394 January 11, 2015
835214 How to make the "Find Printer" button unavailable in Office XP programs Q835214 KB835214 December 31, 2014
274680 How to use MFC to retrieve a list of macro names in an Office document Q274680 KB274680 December 23, 2014
309136 How to disable a custom menu command and toolbar button by using a system policy in Office XP Q309136 KB309136 June 19, 2014
308304 How to create a shortcut to Setup.exe for users to install Office XP with administrator permissions Q308304 KB308304 June 19, 2014
817093 How to troubleshoot Office XP Setup problems on Windows 2003 Server Q817093 KB817093 February 27, 2014
312976 HOW TO: Prevent Users from Sending Clip Organizer Files as E-mail Attachments in Office XP Q312976 KB312976 November 2, 2013
306422 HOW TO: Create an Office XP Smart Tag DLL by Using Visual C# .NET Q306422 KB306422 November 2, 2013
818212 How to use Office XP in a clustered server environment Q818212 KB818212 November 1, 2013
884663 How to enter Hijri date on Microsoft Excel XP (2002). Q884663 KB884663 October 27, 2013
295005 HOW TO: Export an XML Spreadsheet File into Generic XML in Excel 2002 Q295005 KB295005 October 26, 2013
289260 HOW TO: Save a Workbook as a Web Page in Excel 2002 Q289260 KB289260 October 26, 2013
814562 How to programmatically delete the Window Control menu commands in Excel 2002 Q814562 KB814562 October 25, 2013
292187 HOW TO: Use Small Business Financial Manager in Excel 2002 Q292187 KB292187 October 23, 2013
291358 How to use the Paste Options button in Excel Q291358 KB291358 September 23, 2013
193006 How to reset personal menus in Office XP and Office 2000 programs Q193006 KB193006 September 3, 2013
286267 How to create a Smart Tag DLL in Visual Basic for use in Office XP Q286267 KB286267 May 22, 2013
290576 How to run multiple versions of Office on one computer Q290576 KB290576 November 16, 2012
871146 How to troubleshoot general printing problems in Windows 2000 when you are using Office products Q871146 KB871146 October 12, 2012
923505 How to install the Microsoft Office Compatibility Pack so that you can open and save Office Open XML formats in earlier versions of Microsoft Office Q923505 KB923505 August 13, 2012
298041 HOW TO: Install Internet Explorer 5.5 with Office XP on Windows 2000 Q298041 KB298041 July 31, 2012
313092 How to set custom AutoCorrect settings by configuring a system policy in Office XP Q313092 KB313092 July 20, 2012
290361 How to troubleshoot Office Kernel32.dll errors in Windows 98 Q290361 KB290361 July 20, 2012
316934 How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET Q316934 KB316934 September 23, 2011
66033 Hexadecimal Values Changed When Imported from .CSV File Q66033 KB66033 September 19, 2011
870622 How to troubleshoot problems that you may experience when you try to print to a local printer by using Office programs in Windows XP Q870622 KB870622 September 18, 2011
305095 How to find Office XP updates Q305095 KB305095 September 12, 2011
2519419 How to obtain a new product key for a Microsoft Office suite Q2519419 KB2519419 April 7, 2011
214295 How to bypass the Text Import Wizard when you import files in Excel Q214295 KB214295 September 25, 2009
266700 How to troubleshoot installation from a CD or DVD for Office XP Q266700 KB266700 April 7, 2009
316587 How to automate embedded Office ActiveX documents with C++ Q316587 KB316587 March 23, 2009
198703 How to automate Excel from a client-side VBScript Q198703 KB198703 March 23, 2009
153307 How to call Microsoft Excel macros that take parameters Q153307 KB153307 March 23, 2009
870968 How to troubleshoot general printing problems in Windows Server 2003 when you use Office products Q870968 KB870968 October 29, 2008
823002 How to write context numbers in excel Q823002 KB823002 August 25, 2008
821091 HowTo: Formula to Find Number of Weekdays Between Dates Q821091 KB821091 August 25, 2008
816562 How to change connection information for a query in Excel Q816562 KB816562 May 13, 2008
177512 How to select a compatible printer driver for your printer How to select a compatible printer driver for your printer when you use Office 97, Office 2000, or Office XP Q177512 KB177512 April 29, 2008
929302 How to disable the prompt to download the Microsoft Office Compatibility Pack Q929302 KB929302 December 4, 2007
822238 How to understand the repair feature in Office 2003 and in Office XP Q822238 KB822238 December 4, 2007
313138 How to synchronize an Office XP client with the administrative installation point Q313138 KB313138 December 4, 2007
309190 How to troubleshoot an Office XP installation on Windows 2000 that appears to stop Q309190 KB309190 December 4, 2007
307791 How to apply an update to an Office XP administrative installation point by using IntelliMirror Q307791 KB307791 December 4, 2007
298088 How to obtain a Volume License key for Enterprise Editions of Office XP Q298088 KB298088 December 4, 2007
296603 How to use an Office XP Setup log file to troubleshoot Setup problems in Office XP Q296603 KB296603 December 4, 2007
291331 How to check the version of Office XP Q291331 KB291331 December 4, 2007
290309 HOW TO: Install Office XP on Windows NT 4.0 SP6a Q290309 KB290309 December 4, 2007
290121 How to install Windows 98 to a new folder to troubleshoot problems in Office XP Q290121 KB290121 December 4, 2007
283686 How to use command-line switches for Office XP setup Q283686 KB283686 December 4, 2007
281933 How to deploy additional packages with the installation of Office XP Q281933 KB281933 December 4, 2007
932127 How to modify an existing Office policy file (.adm file) for Office 2003 and for Office XP to set the save-as default file format to include the new OpenXML file formats of the 2007 Office programs Q932127 KB932127 October 15, 2007
288367 How to configure Office applications to run under a specific user account Q288367 KB288367 August 23, 2007
288732 How To Deploy the Office XP Web Components in an Office Program Q288732 KB288732 July 19, 2007
288368 How to configure Office applications for automation from a COM+/MTS package Q288368 KB288368 July 2, 2007
309301 HOW TO: Handle Events for Excel by Using Visual C++ .NET Q309301 KB309301 June 29, 2007
306686 How To Run Office Macros Using Automation From Visual C++ .NET Q306686 KB306686 June 29, 2007
306682 How to run Office macros by using Automation from Visual Basic .NET Q306682 KB306682 June 29, 2007
303294 How to use Automation to get and to set Office Document properties with Visual Basic .NET Q303294 KB303294 June 29, 2007
302815 HOW TO: Handle Events for Excel by Using Visual C# .NET Q302815 KB302815 June 29, 2007
302814 HOW TO: Handle Events for Excel by Using Visual Basic .NET Q302814 KB302814 June 29, 2007
110006 How to reset the Update Remote References option in Excel Q110006 KB110006 June 4, 2007
271736 How to add Excel LinkedCell support to your ATL ActiveX control Q271736 KB271736 May 31, 2007
248822 How to use custom functions with the Spreadsheet component Q248822 KB248822 May 31, 2007
319180 How to transform a DataSet to spreadsheet XML for Excel by using Visual Basic .NET and ASP.NET Q319180 KB319180 May 18, 2007
306058 How to create an Office XP Smart Tag DLL by using Visual Basic .NET Q306058 KB306058 May 16, 2007
253501 How to pass a COleDispatchDriver as an argument for a method expecting a VARIANT Q253501 KB253501 May 14, 2007
238983 How to trap events exposed by Office applications Q238983 KB238983 May 11, 2007
291218 How to use Excel startup folders in Excel 2002 Q291218 KB291218 May 7, 2007
290140 How to run the sample code for the Office XP programs from Knowledge Base articles Q290140 KB290140 May 7, 2007
300950 How to troubleshoot custom Smart Tags in Office Q300950 KB300950 April 13, 2007
317405 How to implement the Application.AutomationSecurity property in Office XP Q317405 KB317405 April 9, 2007
317535 HOW TO: Call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office Q317535 KB317535 March 29, 2007
308408 How To Use Automation to Get and Set Office Document Properties from a Managed C++ Client Q308408 KB308408 March 29, 2007
302281 How to obtain the window handle for an Office Automation server by using Visual Basic .NET Q302281 KB302281 March 29, 2007
301982 How to automate Microsoft Excel from Visual Basic .NET Q301982 KB301982 March 29, 2007
292596 How To Create a Smart Tag DLL in ATL For Use in Office XP Q292596 KB292596 March 29, 2007
288366 How to configure Office applications to run under the interactive user account Q288366 KB288366 March 28, 2007
290232 How to manage the Office XP templates in Office programs Q290232 KB290232 March 22, 2007
186898 How To Read Compound Document Properties Directly with VC++ Q186898 KB186898 February 12, 2007
181473 HOWTO: Use OLE Automation from a C Application Rather Than C++ Q181473 KB181473 February 12, 2007
178781 How to automate Excel using MFC and worksheet functions Q178781 KB178781 February 12, 2007
178474 How To Build an Add-in (XLL) for Excel Using Visual C++ Q178474 KB178474 February 12, 2007
214011 How to create a column chart with two Y-axes in Excel Q214011 KB214011 February 8, 2007
843621 How to format Sub procedures in Visual Basic for Applications Q843621 KB843621 February 6, 2007
288972 How to suppress the printing of errors in workbook cells in Excel 2002, Excel 2003 and Excel 2007 Q288972 KB288972 February 5, 2007
812072 How to copy an Office file to a disk Q812072 KB812072 February 1, 2007
330383 How to determine whether your workbook contains links to external data in Excel 2002 and Excel 2003 Q330383 KB330383 February 1, 2007
329228 How to make sure that your Office XP document has a valid digital signature Q329228 KB329228 February 1, 2007
313454 How to clear the Most Recently Used list (MRU) list in Office programs Q313454 KB313454 January 31, 2007
313048 HOW TO: Change the Default "Save Prompt" Text When Users Save an Office XP Document in an Alternate Format Q313048 KB313048 January 31, 2007
304494 How to use Visual Basic for Applications in Excel Q304494 KB304494 January 31, 2007
302295 How To Obtain the Window Handle for an Office Automation Server by Using Visual C# .NET Q302295 KB302295 January 31, 2007
293184 HOW TO: Determine the Order in Which Shapes Are Added to Diagrams in Office Programs Q293184 KB293184 January 31, 2007
291209 How to prevent the automatic creation of hyperlinks in Excel Q291209 KB291209 January 31, 2007
291064 How to save files in other formats in Excel 2002 Q291064 KB291064 January 31, 2007
290374 How to display all menu commands in Office XP programs Q290374 KB290374 January 31, 2007
290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
289245 HOW TO: Use the Excel Formula Evaluator in Excel 2002 Q289245 KB289245 January 31, 2007
288986 HOW TO: Use Text-to-Speech in Excel 2002 Q288986 KB288986 January 31, 2007
288981 HOW TO: Use Speech Recognition to Select Cells, Rows, and Columns in Excel Q288981 KB288981 January 31, 2007
288964 How to insert a picture into the header or footer in Excel 2002 Q288964 KB288964 January 31, 2007
303872 How To Create an Excel Macro by Using Automation from Visual C# .NET Q303872 KB303872 January 30, 2007
303296 How To Use Automation to Get and to Set Office Document Properties with Visual C# .NET Q303296 KB303296 January 30, 2007
303018 HOWTO: Use Automation to Create Office Command Bars and Controls with Visual C# .NET Q303018 KB303018 January 30, 2007
286460 How To Set the Mask and Picture Properties for Office XP CommandBars Q286460 KB286460 January 29, 2007
285884 How to determine whether VBA is enabled for Office applications Q285884 KB285884 January 29, 2007
285337 How To Create a Visual Basic Automation Add-in for Excel Worksheet Functions Q285337 KB285337 January 29, 2007
283633 HOW TO: Display or Hide the Ask a Question Box in Microsoft Office Q283633 KB283633 January 29, 2007
282855 How to create and use one-input data tables in Microsoft Excel Q282855 KB282855 January 29, 2007
279721 How to use Dynamic Data Exchange (DDE) with Word and Excel from Visual C++ Q279721 KB279721 January 29, 2007
278976 How To Use XSL to Transform Excel XML Spreadsheet for Server-Side Use Q278976 KB278976 January 29, 2007
272729 How to import data with more than 256 fields or columns into Excel Q272729 KB272729 January 29, 2007
271856 Hyperlink does not work when pasted or imported Q271856 KB271856 January 29, 2007
269168 How to recognize the difference among Excel 97 files, Excel 2000 files, and Excel 2002 files by using Visual C++ 6.0 Q269168 KB269168 January 27, 2007
268007 How to sort more than three columns in Excel Q268007 KB268007 January 27, 2007
266318 How to retrieve the name of an Office document that contains an MFC ActiveX control Q266318 KB266318 January 27, 2007
261997 How To Obtain the Window Handle for an Office Automation Server with MFC Q261997 KB261997 January 27, 2007
259137 How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro Q259137 KB259137 January 27, 2007
257464 Hyperlinks in an e-mail message do not work in Office 2000 or in Office 2002 programs Q257464 KB257464 January 27, 2007
238228 How to build an Office 2000 COM add-in in Visual Basic Q238228 KB238228 January 24, 2007
238133 How To Write a DDEML Server for Excel and Use it with NetDDE Q238133 KB238133 January 24, 2007
231614 How To Automate Excel to Create a New Workbook from Delphi Q231614 KB231614 January 24, 2007
225029 How To Determine Which Version of Excel Wrote a Workbook Q225029 KB225029 January 24, 2007
223789 How to minimize metadata in Microsoft Excel workbooks Q223789 KB223789 January 24, 2007
223396 How to minimize metadata in Office documents Q223396 KB223396 January 24, 2007
214797 How To Automate Excel Using Perl for Win32 Q214797 KB214797 January 24, 2007
214259 How to use grouping for fields in a PivotTable in Excel Q214259 KB214259 January 24, 2007
214249 How to use the Conditional Sum Wizard in Microsoft Excel Q214249 KB214249 January 24, 2007
213923 How to use AutoFilter to filter records based on cell formatting in Excel Q213923 KB213923 January 24, 2007
213915 How to create a Gantt chart using hours as the scale Q213915 KB213915 January 24, 2007
213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002 Q213837 KB213837 January 24, 2007
213773 How to create data validation circles for printing in Excel Q213773 KB213773 January 24, 2007
213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002 Q213772 KB213772 January 24, 2007
213754 How to customize a custom toolbar button Q213754 KB213754 January 24, 2007
213740 How to record a macro using relative cell references in Excel Q213740 KB213740 January 24, 2007
213638 How to create a macro that counts comments Q213638 KB213638 January 24, 2007
213495 How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values Q213495 KB213495 January 24, 2007
213438 How to programmatically select every nth row in a range in Excel Q213438 KB213438 January 24, 2007
212144 Hyphens and apostrophes are sorted after alphabetic letters in Excel Q212144 KB212144 January 24, 2007
211835 How to control the placement of objects Q211835 KB211835 January 24, 2007
205548 How to use A functions in Excel Q205548 KB205548 January 23, 2007
194611 How To Create and Call an Excel Macro Programmatically from VB Q194611 KB194611 January 23, 2007
186122 How to use MFC to automate Excel 2000 and Excel 2002 and obtain an array from a range in Excel 2000 and Excel 2002 Q186122 KB186122 January 23, 2007
186120 How To Use MFC to Automate Excel and Fill a Range with an Array Q186120 KB186120 January 23, 2007
181201 HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel Q181201 KB181201 January 22, 2007
180312 HOWTO: Use Automation to Set the Printer from an MFC Project Q180312 KB180312 January 22, 2007
179706 How to use MFC to automate Excel and create and format a new workbook Q179706 KB179706 January 22, 2007
178783 How To Use MFC to Create a Microsoft Excel Chart Q178783 KB178783 January 22, 2007
178782 How To Use MFC to Automate Excel and Navigate Worksheets Q178782 KB178782 January 22, 2007
178605 How To Determine the Version of a Microsoft Excel Workbook Q178605 KB178605 January 22, 2007
164317 How to sum a range of cells based on a number format in Excel Q164317 KB164317 January 19, 2007
149235 How to help prevent file corruption in Excel Q149235 KB149235 January 19, 2007
123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 2007
310744 How To Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC Q310744 KB310744 January 17, 2007
307292 How To: Dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET Q307292 KB307292 January 17, 2007
306022 How to transfer data to an Excel workbook by using Visual Basic .NET Q306022 KB306022 January 17, 2007
304661 How To Use Visual Basic .NET for Binding for Office Automation Servers Q304661 KB304661 January 17, 2007
259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic Q259971 KB259971 January 17, 2007
823573 How to determine the number of unique items in a list in versions 97, 2000, and 2002 of Excel Q823573 KB823573 January 16, 2007
302896 How To Build an Office COM Add-in by Using Visual Basic .NET Q302896 KB302896 December 25, 2006
922665 How to change the source for a client computer from an updated administrative installation point to an Office XP original release version baseline source Q922665 KB922665 December 15, 2006
907349 How to troubleshoot video issues in Office programs Q907349 KB907349 December 7, 2006
61090 How to use cell references and defined names in criteria in Excel Q61090 KB61090 November 23, 2006
290148 How to use the Undo feature with inserted objects in Office programs Q290148 KB290148 November 21, 2006
180625 How to use Automation to modify the Office menu Q180625 KB180625 November 21, 2006
48198 How to set the starting page number in the header or footer in Excel Q48198 KB48198 November 16, 2006
287482 HOW TO: Add the Workbook Path to the Header and Footer in Excel Q287482 KB287482 October 23, 2006
287120 How to automate Excel Text to Speech in another Office program Q287120 KB287120 October 23, 2006
142588 How to compare two cells and ignore leading and trailing spaces by using the TRIM worksheet function Q142588 KB142588 September 13, 2006
294933 How to use the Application Recovery tool in Office 2002 and in Office 2003 Q294933 KB294933 July 27, 2006
288940 How to check and manage the status of links in Excel 2002 or later versions of Excel Q288940 KB288940 May 11, 2006
306683 HOW TO: Run Office Macros by Using Automation from Visual C# .NET Q306683 KB306683 May 5, 2006
305799 HOW TO: Develop Database-Driven Smart Tags for Office by Using Visual Basic for Windows Q305799 KB305799 April 13, 2006
307731 How to add a digital signature to a custom macro project in Office 2003 and Office XP Q307731 KB307731 April 12, 2006
300639 How to handle corrupted Excel workbooks by saving them in the SYLK format in Excel 2003 or in Excel 2002 Q300639 KB300639 March 29, 2006
313053 HOW TO: Customize Error Messages in an Office XP Program by Configuring a System Policy Q313053 KB313053 February 16, 2006
312998 HOW TO: Specify a Path for Workgroup Templates in Office XP Programs by Using a System Policy Q312998 KB312998 February 16, 2006
312991 HOW TO: Disable the Web Toolbar Components in Office XP Programs by Using a System Policy Q312991 KB312991 February 16, 2006
312958 How to change the Office Assistant options in Office XP programs by configuring a system policy Q312958 KB312958 February 16, 2006
309267 How to establish local crash-reporting server for users to submit error reports when Office XP crashes Q309267 KB309267 February 16, 2006
309258 How to import a Windows registry file into a transform file in Office XP Q309258 KB309258 February 16, 2006
309257 How to include Windows registry values by using a transform (MST) file when you deploy Office XP Q309257 KB309257 February 16, 2006
309120 How to customize Office XP for a hard disk image to configure a complete user system Q309120 KB309120 February 16, 2006
309022 HOW TO: Redirect or Disable the Office on the Web Connection for Office XP Programs Q309022 KB309022 February 16, 2006
308297 How to create a customized copy of the Office XP CD for users who cannot install from a network share Q308297 KB308297 February 16, 2006
307783 How to apply an administrative update to an Office XP administrative installation point by downloading update files Q307783 KB307783 February 16, 2006
307732 How to add a Windows 2000 ADM template to a Group Policy snap-in in Office XP Q307732 KB307732 February 16, 2006
296468 HOW TO: How to Create Windows Installer Shortcuts with One Restart in Office XP Q296468 KB296468 February 16, 2006
291072 How to create multiple views, create a report, and print a report in Excel 2002 and Excel 2003 Q291072 KB291072 February 13, 2006
830502 How to customize menus and menu bars in Excel Q830502 KB830502 January 11, 2006
826920 How to use the Send To command to send worksheet selections as an e-mail message in Excel 2003 Q826920 KB826920 January 11, 2006
222101 How to find and use Office object model documentation Q222101 KB222101 November 22, 2005
303017 How To Use Automation to Create Office Command Bars and Controls with Visual Basic .NET Q303017 KB303017 August 23, 2005
280290 How to install an Excel Add-in (XLA or XLL) with Automation Q280290 KB280290 June 10, 2005
288363 HOW TO: Remove Template Listings in Excel Q288363 KB288363 June 8, 2005
240794 How to Determine the Path for an Office Application Q240794 KB240794 July 15, 2004
199841 How To Display ASP Results Using Excel in IE with MIME Types Q199841 KB199841 July 15, 2004
303871 How To Create an Excel Macro by Using Automation from Visual Basic .NET Q303871 KB303871 July 14, 2004
238393 How To Use Visual C++ to Access DocumentProperties with Automation Q238393 KB238393 July 13, 2004
247985 How To Find the Path and Version of an Office Application from Visual C++ Q247985 KB247985 June 30, 2004
219430 How To Create/Format an Excel Workbook Using Visual J++ Automation Q219430 KB219430 June 30, 2004
142387 How To Create Excel Chart w/OLE Automation from Visual Basic Q142387 KB142387 June 30, 2004
311731 How To Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET Q311731 KB311731 June 29, 2004
308292 How To Automate Excel to Create And Format a New Workbook Using C++ .NET and MFC Q308292 KB308292 June 29, 2004
307949 HOW TO: Configure a System Policy to Control the Recently Used File List in an Office XP Program Q307949 KB307949 June 25, 2004
320523 HOW TO: Check the Type of a COM Object (System.__ComObject) with Visual C# .NET Q320523 KB320523 December 15, 2003
307021 HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET Q307021 KB307021 December 12, 2003
289845 HOW TO: Change the Voice That Is Used for Text to Speech in Excel Q289845 KB289845 November 25, 2002

Excel 2002 (Excel XP) articles, fixes and updates - letter H