Home > Excel Help Portal > Programming Excel

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

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.

1. Creating a Table of Contents with hyperlinks to the sheets in the workbook is simple using the BuildTOC() macro. XL2000 provides hypertext links in your Excel spreadsheets. The links generated here will be to sheets within your workbook.... Keywords: Add-In, Charts, AutoCorrect, Sorting, Export, OLE, AutoFormat, Colors, Custom Number Formats, Fonts, Outline, Styles, Arrays, Errors, Formulas, Links, Printing, Class, Clipboard, Command Button, VBA, Macro, Object, User Defined Function, VBE, Files, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, MID, INDIRECT, VLOOKUP, OFFSET, CELL, MATCH, INDEX

 
2. Rearranging Data in Columns Many of the macros here are useful for reformatting name and address listings, and others for creating test data. ... Keywords: Add-In, SERIES, Sorting, Dates, Colors, Fonts, Format, Styles, Arrays, Errors, Formulas, Defined Name, PivotTables, Printing, VBA, Macro, UDF, User Defined Function, Toolbar, HTML, Hyperlinks, Web, Comments, TRIM, REPT, TEXT, LEFT, TRANSPOSE, MID, RIGHT, LEN, CODE, CLEAN, CHAR, REPLACE, ADDRESS, CELL, ROW, INDIRECT, FIND, LOWER, UPPER

 
3. Date & Time There is enough confusion between US and UK dates without dealing with 2-digit years. Suggest you make changes such as the following so that all of your dates will display as four digit years. If you do not do this you may not be able to distinguish which part of the date is the year, the month, day; and have further difficulty knowing whether you actually have a 19xx year or a 20xx year.... Keywords: Add-In, Analysis ToolPak, Charts, SERIES, Advanced Filter, Query, Dates, Days, Holidays, Months, Networkdays, Years, API, Colors, Custom Number Formats, Fonts, Styles, Symbol, Arrays, Errors, Formulas, Sounds, Page Setup, VBA, Macro, User Defined Function, Templates, HTML, Links, Web, Comments, Window, TEXT, NOW, MOD, DATEVALUE, TIME, COUNTIF, DATEDIF, ROUNDDOWN, MID, TODAY, DB, WEEKDAY, CHOOSE, WEEKNUM, EDATE, TIMEVALUE, MROUND, FLOOR, CEILING, ROUNDUP, MIN, MAX, LEN, CELL, CODE, COUNTA

 
4. Shortcut Keys in Excel 2000 (Excel Version 9) Create your table of builtin shortcut keys as follows: HELP -- Index -- Shortcut keys -- built-in keyboard shortcuts copy and paste each category into a ShortCutKeys spreadsheet Put topics in Red 12 point bold font, the rest Black 10 point Normal (all Arial) Alternatives to shortcut keys: Toolbar... Keywords: Add-In, Charts, SERIES, AutoShapes, AutoFilter, Sorting, Borders, Colors, Fonts, Format, Outline, Styles, Symbol, Arrays, Errors, Formulas, Links, Speech, Defined Name, PivotChart, PivotTables, Printing, Clipboard, Command Button, VBA, Macro, Object, Error Message, Files, Macintosh , Menu Command, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Cell Note, Comments, Window, FIND, RIGHT, SIGN, LEFT

 
5. How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Explains how to use ActiveX controls in UserForms in Excel. Examples of Visual Basic for Applications code are... KB#829070. Keywords: Query, Days, Colors, Fonts, Format, Styles, Arrays, Errors, Password, Startup, Defined Name, Combo Box, Command Button, VBA, Macro, Object, Spin Button, UserForm, Files, Web, Validation, Window

 
6. Slow Response, Memory Problems, and Speeding up Excel Don't use this feature if you don't need it. Results reported in XL2000, from XL97 would be similar If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *.xls you will see the following Microsoft Excel 5.0/7.0 saving XXXXXXX.xls on your status bar where you normally see Ready toward the... Keywords: Add-In, Charts, Dates, Days, API, DLL, Export, Microsoft Access, Colors, Custom Number Formats, Fonts, Patterns, Styles, Arrays, Errors, Formulas, Links, Password, Speech, Startup, Page Setup, Printing, VBA, Macro, Object, VBE, AutoSave, CD-ROM, Circular References, Error Message, Files, Registry, Templates, Toolbar, Text Files, Hyperlinks, Internet Explorer, Web, Comments, Window, INFO, CELL, OFFSET, TODAY, INDIRECT, NOW, RAND, MAX, FIND, MID

 
7. Event Macros, Worksheet Events and Workbook Events Excel 2002 includes format as a change Event so possibly this should change the colorindex at the end and turn Event off/on around it. But I don't have Excel 2002.... Keywords: Criteria, Sorting, Dates, Days, Borders, Colors, ColorIndex, Conditional Formating, Fonts, Gridlines, Styles, Arrays, Errors, Formulas, Links, Printing, VBA, Macro, Object, VBE, CD-ROM, Error Message, Files, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Validation, Window, MIN, NOW, TIME, ROW, SUBTOTAL, MATCH, COUNTIF, PROPER, OFFSET

 
8. Onsite pages and related off-site material for Excel pages Keywords: Add-In, Analysis ToolPak, Charts, SERIES, Graphic, AutoFilter, Criteria, Query, Rank, Sorting, Wildcard, Dates, Days, Months, Years, Download, API, DLL, Export, OLE, Statistics, Borders, Colors, Custom Number Formats, Fonts, Gridlines, Patterns, Styles, Symbol, Arrays, Errors, Formulas, Links, Sounds, Startup, PivotTables, Printing, Class, Clipboard, Macro, VBA, VBE, CD-ROM, Corrupted, Files, Registry, Templates, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Auditing, Column Width, Comments, Validation, Window, FIND, COUNTA, COUNTIF, DATEDIF, OFFSET, INDIRECT, MAX, HLOOKUP, VLOOKUP, PROPER, REPT, INFO, CELL, NOW, RAND, TODAY

 
9. Show FORMULA or FORMAT of another cell Not satisfied with the methods of showing formulas in Excel: (#getformula) Tools -- Options -- View -- (formula on/off) Ctrl+` is the equivalent shortcut (toggle on/off) -- accent grave to left of the 1,2,3 on the top row Also see Select cells with formulas or constants which you can tab through or... Keywords: Add-In, Criteria, Sorting, Days, Download, API, Statistics, Borders, Colors, Custom Number Formats, Fonts, Outline, Patterns, Styles, Symbol, Arrays, Errors, Formulas, Links, Printing, Class, VBA, Macro, Object, UDF, User Defined Function, Files, Toolbar, HTML, Hyperlinks, Web, Auditing, Comments, Validation, Window, NOW, VALUE, DATEDIF, REPT, COUNTA, COUNTIF, OFFSET, LARGE, INDEX, BAHTTEXT, LEN, CODE, TRIM, MOD, CHAR

 
10. Backup your files, always take backups See Workbook Recovery for files left behind from Excel without a file extension such as 7655D900 or 2CB4D900 with a file type of "File" instead of "Microsoft Excel Workbook", Immediate solutions -- Backup on Demand -- Excel oriented (#demand) Don't forget to check if UNDO will work for you, but you... Keywords: Add-In, AutoCorrect, Months, Download, Export, OLE, Colors, Fonts, Format, Styles, Errors, Formulas, Links, Password, Sounds, Startup, Printing, VBA, Macro, UDF, AutoSave, CD-ROM, Corrupted, Error Message, Files, Registry, Save A File, Toolbar, HTML, Web, Comments, Window, LEFT

 
11. Color Palette and the 56 Excel ColorIndex Colors This page contains some VBA macros and User Defined Functions. If you need assistance to installing eitherplease refer to Install a Macro or User Defined Function on my Formula page. Scope of the Color Palette: Each workbook has it's own palette. To change the default, change your book.xlt template... Keywords: Add-In, Analysis ToolPak, Charts, Graphic, Text Box, Sorting, Dates, Borders, Colors, ColorIndex, Fonts, Format, Gridlines, Patterns, Styles, Errors, Formulas, Links, Printing, VBA, Macro, UDF, User Defined Function, VBE, Smart Tag, Templates, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, COUNTIF, RIGHT

 
12. Toolbars, Custom Buttons and Menus Sample Screen shot for Excel 2000 A view with individual toolbars identified in Excel 2000 is not included here because of the space it would occupy on this page and the size of the download. But you can see it and additional toolbars for both Excel 2000 and and Excel 95 ) on Figure 3, another... Keywords: Add-In, Sorting, Download, OLE, Borders, Colors, Fonts, Format, Patterns, Styles, Errors, Formulas, Links, Speech, Startup, Page Setup, Printing, Clipboard, VBA, Macro, Files, Templates, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, FIND

 
13. Fill-Handle, Replication and use of the Mouse Equivalent Examples With the data in cell A3, to be copied down to cell A30: Select cell A3 Point to the fill handle (the black square in the lower right corner of the selection) When the pointer changes to a black cross, drag down to A30 abc The items in bold were replicated (propagated) down... Keywords: SERIES, AutoFilter, Dates, Days, Months, Borders, Fonts, Format, Errors, Formulas, Links, Startup, Page Setup, Printing, VBA, Macro, Object, VBE, Files, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, ROW, OFFSET, LARGE, INDIRECT, CELL, MID

 
14. Mail Merge, Printing Labels using Mail Merge with data from Excel Excel can be used to supply the data to mailmerge in MS Word. I found this a little tricky first time but have done this from both XL95 and XL2000. Excel makes a nice table column for name, address, city, zip state, zip code. Excel does not give you reformatting options to create another sheet... Keywords: Query, Sorting, Months, Download, DDE, SQL, Fonts, Format, Patterns, Styles, Symbol, Errors, Formulas, Links, Printing, Macro, Object, VBA, VBE, Files, Templates, HTML, Hyperlinks, Web, Comments, Window, TRIM, MATCH

 
15. Worksheets in VBA Coding and in Worksheet Formulas Keywords: Sorting, API, Colors, Fonts, Format, Arrays, Errors, Formulas, Links, Startup, Clipboard, VBA, Macro, User Defined Function, Setup, Files, Templates, Toolbar, HTML, Hyperlinks, Web, Comments, Window, CELL, INDIRECT, MID, LARGE

 
16. How to customize menus and menu bars in Excel Describes how to use the Microsoft Visual Basic Editor to customize menu bars, menus, menu items, submenus, and shortcut menus in Excel. Provides step-by-step instruction and code... KB#830502. Keywords: Charts, Combo Box, VBA, Macro, Object, Menu Command, Toolbar, Web, Window

 
17. Excel to HTML conversions The code referred to on this page are VBA macros. If you need assistance to install macros please refer to Getting Started with Macros or for even more information for more depth after using installing/using some macros see Install a Macro or User Defined Function on my Formula page. The generated... Keywords: Add-In, Charts, Query, Sorting, Download, Export, XML, Borders, Colors, Fonts, Format, Styles, Formulas, Links, Printing, Clipboard, VBA, Macro, Object, User Defined Function, Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, ROW

 
18. Delete Cells/Rows in Range, based on empty cells, or cells with specific values Assistance to Install a Macro or User Defined Function on my Formula page. Delete Empty Cells but don't disturb rows The DEL95HTMLemptyCells is designed to clean up the mess that Excel 95 creates when pasting from a web page into Excel. My experience with pasting Excel 95 was that instead of... Keywords: Add-In, SERIES, Sorting, Colors, ColorIndex, Format, Errors, Formulas, VBA, Macro, Object, User Defined Function, HTML, Web, Comments, Discontiguous, TRIM, FIND, ROW

 
19. Shortcut Keys in XL95 (Excel Version 7) Rather than just telling you to create a Shortcut keys sheet in an Excel file I decided to show you what mine looks like. You should create your own, of course. Creation of Shortcut keys spreadsheet Shortcuts are entirely optional. In XL95 a shortcut key can be assigned to a macro using: Tools --... Keywords: Add-In, Charts, SERIES, AutoFilter, Borders, Format, Outline, Styles, Arrays, Formulas, PivotTables, Printing, Command Button, VBA, Macro, Object, Macintosh , Menu Command, Toolbar, Web, Cell Note, Comments, Window, FIND, SIGN, LEFT, RIGHT

 
20. How to transfer Data to an Excel Workbook by Using Visual Basic .NET This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual Basic .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works... KB#306022. Keywords: Query, Download, ActiveX, OLE, SQL, XML, Fonts, Format, Styles, Arrays, Errors, Defined Name, Clipboard, Combo Box, VBA, Object, Files, Text Files, Web, Parse, DB

 
21. Strings and Manipulations Text Functions, Workbook Before continuing please be aware of the following information available in Excel HELP WorksheetDescription VBA CHAR Listed by Tom Ogilvy from HELP (VBA HELP), but I can't find which help. Action Keywords Compare two strings. StrComp Convert strings. StrConv Convert to... Keywords: Sorting, Wildcard, Download, Fonts, Format, Arrays, Errors, Formulas, Links, VBA, Macro, UDF, User Defined Function, Error Message, HTML, Hyperlinks, Web, Comments, CLEAN, ASC, CONCATENATE, FIND, LEFT, LEN, MID, PROPER, REPT, RIGHT, MAX, EXACT, SUBSTITUTE, CODE, LOWER, UPPER, COUNTIF, TRIM, CALL, CHAR, ROMAN, REPLACE

 
22. Considerations for ServerSide Automation of Office Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with... KB#257757. Keywords: Charts, ActiveX, DDE, OLE, Third-Party, XML, Format, Errors, Printing, Clipboard, Macro, Object, VBA, Setup, Files, Registry, HTML, Internet Explorer, Links, Web

 
23. How to use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider;... KB#316934. Keywords: Data Table, Query, Export, Microsoft Access, OLE, Sales, Fonts, Format, Styles, Errors, Formulas, Defined Name, VBA, Object, File Name, Window, DB

 
24. Install Macros and User Defined Functions The content of this page was formerly part of my Formula and Format page. Install a Macro or User... Keywords: Add-In, OLE, Format, Errors, Formulas, Links, Class, VBA, Macro, Object, UDF, User Defined Function, VBE, Files, Toolbar, Web, Comments, Window, CALL

 
25. How to Minimize Metadata in Microsoft Excel Workbooks This article explains various methods that you can use to minimize the amount of metadata in your workbooks. When you create, open, or save a workbook in Microsoft Excel, the workbook may contain content that you do not want to share with others... KB#223789. Keywords: OLE, Statistics, Colors, Fonts, Format, Styles, Formulas, Links, Page Setup, Printing, Macro, Object, VBA, Files, Templates, Hyperlinks, Web, Comments

 
26. Lastcell, Reset Last Used Cell If you place some data in a remote location of your spreadsheet and later delete that data Excel retains a memory of the last cell in use even though it is no longer in use. To find the last cell in use. This is the convergence of the highest row in use and the highest column in use (or the memory... Keywords: Borders, Colors, Format, Arrays, Errors, Formulas, Sounds, Printing, VBA, Macro, Setup, Files, Toolbar, Text Files, Hyperlinks, Web, Comments, INDIRECT, LOOKUP, INDEX, OFFSET, ROW

 
27. How to create an Office XP Smart Tag DLL by Using Visual Basic .NET Smart Tags are a technology that was introduced with Office XP that provides Office users more interactivity with the content of their Office documents. A Smart Tag is an element of text in an Office document that is recognized as having... KB#306058. Keywords: Add-In, Download, DLL, XML, Arrays, Errors, Class, VBA, Macro, Object, Registry, Smart Tag, Templates, Web, Window

 
28. How to troubleshoot errors when you save Excel files Describes how to troubleshoot issues that may occur when you try to save Excel... KB#271513. Keywords: Add-In, ActiveX, Third-Party, Format, Errors, Formulas, Startup, PivotTables, Object, VBA, Error Message, File Name, Files, Save A File, Templates, HTML, Web

 
29. Macro Examples Using XLODBC Functions In the versions of Microsoft Excel mentioned at the beginning of this article, you can use the Microsoft ODBC add-in for Microsoft Excel (XLODBC.XLA) to create macros that interact directly with ODBC through the ODBC driver manager.... KB#124218. Keywords: Add-In, Query, SQL, Arrays, Errors, Class, VBA, Macro, Error Message, Files, Web

 
30. Methods for Transferring Data to Excel from Visual Basic This article discusses numerous methods for transferring data to Microsoft Excel from your Microsoft Visual Basic application. This article also presents the advantages and the disadvantages for each method so that you can choose the solution... KB#247412. Keywords: Text Box, Query, Download, DAO, DDE, OLE, SQL, Fonts, Format, Arrays, Errors, Defined Name, Printing, Clipboard, Macro, Object, VBA, Files, Text Files, Parse, DB

 
31. How to Create MS Access Database from MS Excel Using DAO In some cases, you may want to create a Microsoft Access database from a Microsoft Excel for Windows 95 version 7.0 workbook, but are not able to use Access Links. While the preferred method of moving a Microsoft Excel workbook into Microsoft... KB#151566. Keywords: Charts, Sorting, Microsoft Access, Format, Errors, Links, VBA, Object, Setup, Error Message, Web

 
32. How to create a Smart Tag DLL in Visual Basic for Use in Office XP Smart Tags are a technology introduced with Office XP that provide Office users more interactivity with the content of their Office documents. A Smart Tag is an element of text in an Office document that is recognized as having custom... KB#286267. Keywords: Download, ActiveX, DLL, XML, Arrays, Errors, Class, VBA, Macro, Object, Registry, Smart Tag, Web, Window

 
33. How to Use "On Error" to Handle Errors in a Macro In Microsoft Excel, you can use the On Error statement in a Microsoft Visual Basic for Applications macro (Sub procedure) to trap errors and direct procedure flow to the error-handling statements in a procedure. By using error handling, you make... KB#141571. Keywords: Errors, VBA, Macro, Error Message, Web

 
34. How to Use "On Error" to Handle Errors in a Macro In Microsoft Excel, you can use the On Error statement in a Microsoft Visual Basic for Applications macro ( Sub procedure) to trap errors and direct procedure flow to the error-handling statements in a procedure. By using error-handling, you make... KB#213637. Keywords: Errors, VBA, Macro, Error Message, Web

 
35. How to Embed and Automate Office Documents with Visual Basic When developing an application that uses data in an Office document, it might be beneficial to have that data presented directly within your Visual Basic application so that the user can see and edit the data without having to switch to the... KB#242243. Keywords: ActiveX, OLE, Sales, Borders, Fonts, Format, Styles, Arrays, Errors, VBA, Object, Files, Toolbar, Internet Explorer, Window

 
36. How to Select Cells/Ranges Using Visual Basic Procedures in Excel When you create a Microsoft Visual Basic for Applications macro or procedure, you can choose from a variety of methods for selecting cells, ranges, and named ranges. This article contains sample code that demonstrates some of these methods.... KB#291308. Keywords: Sales, Errors, Class, Macro, Object, VBA, Web

 
37. WorksheetProtection Options Overview This article describes the enhanced worksheet-protection options available in Microsoft Excel... KB#289269. Keywords: AutoFilter, Criteria, Sorting, Format, Password, Defined Name, PivotTables, Object, VBA, Files, Menu Command, Toolbar, Hyperlinks, Internet Explorer, Scenarios

 
38. How to Dismiss a Dialog Box Displayed by an Office Application with Visual Basic When you are automating an Office application from Visual Basic (VB), the Office application may display a dialog box. The dialog box causes the Visual Basic application to appear to stop responding (or hang) because VB is waiting for the dialog... KB#259971. Keywords: ActiveX, Errors, Password, Printing, Class, VBA, Object, File Name, Web, Window

 
39. Overview of Visual Basic Editor Debugging Tools The Microsoft Visual Basic Editor provides a rich set of debugging tools that you can use to troubleshoot problems with your Visual Basic for Applications macro code. This article describes some general debugging techniques that you can use to... KB#165517. Keywords: Printing, VBA, Macro, Object, Toolbar, Web, Window, CODE, MODE, CALL

 
40. How to transform a DataSet to spreadsheet XML for Excel by using Visual Basic .NET and ASP.NET This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas,... KB#319180. Keywords: DLL, SQL, XML, Format, Styles, Errors, Formulas, Password, Class, VBA, Object, Files, Templates, HTML, Internet Explorer, Web

 
41. Contextures Excel Book List Excel Book List Latest update: May 30, 2004 -- original list compiled by Norman Harker* VBA Contact: ddalgleish@contextures.com *Microsoft Excel MVP Norman Harker is an Australian academic specialising in real estate appraisal, investment analysis and real estate financial feasibility... Keywords: SQL, Statistics, Formulas, VBA

 
42. Getting Started with Macros and User Defined Functions If these instructions do not help then try Visual Basic for Applications 101 (Excel) «... Keywords: Add-In, SERIES, Days, Colors, Format, Patterns, Errors, Formulas, Sounds, Startup, Macro, UDF, VBA, VBE, Files, Toolbar, Web, Comments, Window, FIND

 
43. Overview of Excel 2002 Update: June 19, 2002 Microsoft has released an update to Microsoft Excel 2002. This update includes several security updates and other issues that are corrected in the update. This article describes how to download and install the Excel 2002 Update: June 19, 2002. NOTE... KB#323548. Keywords: Charts, AutoShapes, Query, Dates, Download, DDE, XML, Borders, Styles, Errors, Speech, PivotTables, Printing, Combo Box, Macro, Object, VBA, AutoSave, CD-ROM, Error Message, Files, Hyperlinks, Internet Explorer, Web

 
44. How to build an Office COM Addin by Using Visual Basic .NET Microsoft Office 2000 and later support a new, uniform design architecture for building application add-ins to enhance and to control Office applications. These add-ins are called COM add-ins. This step-by-step article discusses Office COM add-ins... KB#302896. Keywords: Add-In, ActiveX, Styles, Arrays, Errors, Startup, Class, VBA, Object, Setup, Error Message, Registry, Templates, Toolbar, Links, Web, Window

 
45. You receive runtime error 429 when you automate Office applications Discusses the run-time error 429 ActiveX component can't create object that can occur when you automate Office 2003 applications and provides information on how to diagnose and resolve common problems that may cause this... KB#828550. Keywords: Dates, Download, ActiveX, OLE, Format, Errors, Object, VBA, Setup, Corrupted, Files, Registry, Templates, Internet Explorer, Web

 
46. How to Determine If Your Workbook Contains Links to External Data Excel workbooks can contain external data ranges that retrieve data from the following data sources: Microsoft SQL Server OLAP Services (OLAP provider) Microsoft Access dBASE Microsoft FoxPro Microsoft Excel Oracle Paradox SQL Server... KB#330383. Keywords: Query, DAO, SQL, Fonts, Arrays, Errors, Formulas, Links, Defined Name, PivotTables, VBA, Macro, Web

 
47. How to dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET When you are automating an Office application from Visual Basic .NET, the Office application may display a dialog box. The dialog box causes the Visual Basic .NET application to appear to stop responding (hang) because the Visual Basic... KB#307292. Keywords: Errors, Password, Printing, VBA, Object, Error Message, File Name, Templates, Web, Window

 
48. FloatingPoint Arithmetic May Give Inaccurate Results This article discusses how Microsoft Excel stores and calculates floating-point numbers. This may affect the results of some numbers or formulas due to rounding and/or data truncation. Overview Microsoft Excel was designed around the IEEE... KB#78113. Keywords: Format, Errors, Formulas, Printing, VBA, Web, ROUND

 
49. XL2GIF and Manipulations The XL2GIF macro on this page was graciously supplied by Harald Staff I thought I might add a little item to your "Save as HTML" stuff. This is a little Excel8/9 routine that prompts for a worksheet range selection and saves this as a GIF image. We use an extended version of this for web-publishing... Keywords: Add-In, Charts, Download, Export, OLE, Colors, Gridlines, Errors, Formulas, Links, Defined Name, Clipboard, VBA, Macro, Files, Toolbar, HTML, Web, Comments, Window

 
50. Issues that are fixed in Excel 2002 by Office XP Service Pack 3 Discusses the issues that are fixed for Excel 2002 by Office XP... KB#836031. Keywords: Add-In, Charts, Text Box, Criteria, Data Table, Query, Sorting, Download, ActiveX, DDE, OLE, SQL, Third-Party, XML, Fonts, Format, Errors, Formulas, Links, Password, Startup, PivotTables, Printing, Combo Box, Macro, Object, VBA, Error Message, Files, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, RANDBETWEEN

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