Home > Excel Help Portal > Excel and the Web

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

Excel and the Web

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses topics about Excel and
the Web.

1. Outlook Express 5.0 through 6.0 Okay, now what about my cousin who invariably sends me email with no subject lines, includes HTML, virus hoaxes. I'll try the harmless one she just sent with newspaper clippings. This one has IncrediMail or at least it has an advertisement for same and it has an external paperclip on the selection... Keywords: Sorting, Days, Months, Download, Statistics, Colors, Errors, Links, Password, Sounds, Clipboard, Setup, Files, Registry, Toolbar, HTML, Internet Explorer, Web, Comments, Window, LEFT, SIGN, RIGHT

 
2. Things you should have that are Free There are some very clear issues here; Advertising, Pop-Ups, Limited support, etc. Read the documentation first and then decide. If you are away from home don't forget to take a wireless card and/or a cable modem card, your friends may have cable even if you don't. On the Second tab of FTP_WS LE... Keywords: Sorting, Days, Download, Colors, Fonts, Links, Password, Startup, Printing, Macro, Object, VBA, Setup, Files, Text Files, HTML, Internet Explorer, Web, Comments, Window

 
3. Excel Newsgroups ©2001 Google When looking at your results be sure to look also at: Before Deja suddenly disappeared on Feb 12, 2001 lots of strange things had happened. A move of servers in 1999 dumped all but the last three days and they slowly recovered back to about March of 1999 by the time it was announced... Keywords: Charts, Sorting, Wildcard, Dates, Days, Years, DDE, OLE, Statistics, Format, Errors, Formulas, Links, Password, Startup, Printing, Macro, UDF, Setup, Files, Macintosh , Templates, HTML, Internet Explorer, Web, Comments

 
4. Stocks, Quotes and keeping track of Keywords: Add-In, Charts, Query, Dates, Days, Years, Download, DDE, Export, ROI, Sales, Statistics, Colors, Format, Links, Password, Macro, VBA, Files, Templates, Text Files, HTML, Hyperlinks, Web, Comments

 
5. Search Page for "My Excel Pages" Related (#related) VBA to invoke a Google search or a dictionary search from within an Excel spreadsheet, creates and invokes a hyperlink via FollowHyperlink. Set up a Search shortcut in your Start Menu for a search of your hard drive (#fnd) You can search your hard drive for a word or a phrase... Keywords: Rank, Sorting, Wildcard, Dates, Months, Statistics, Format, Errors, Links, Printing, VBA, Files, Registry, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
6. Internet Explorer Right-Click Menus Depending on where you right-click in IE you will get different menus. Logo to Left of Title bar Title bar -- Restore, Move (Alt+Space,M, drag with mouse), Size, Minimize, Maximize, Close Menu & Toolbars -- Customize menus and toolbars, Lock Toolbars to prevent theft of homepage & control Menu Bar... Keywords: Add-In, Sorting, Download, Colors, Fonts, Format, Errors, Links, Startup, Printing, Clipboard, User Defined Function, VBA, Error Message, Files, Registry, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
7. Bookmarklets (JavaScript Favelets) 0  James Highlight Links, variations most Yellow IE only, one in garish green. At least two toggle color, the one selected earlier for Mozilla works in both but it resets rather than retaining font color. Count strings, images, fails in IE Scroll Position, Show document size, Titles, all fail in IE... Keywords: Sorting, Borders, Colors, ColorIndex, Fonts, Format, Styles, Arrays, Links, Startup, Toolbar, HTML, Internet Explorer, Web, Comments, Validation, Window, TEXT

 
8. 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

 
9. Collections Dim wkBook As Workbook Dim wkSheet As Worksheet Dim x As Long, cSht As Long For Each wkBook In Workbooks x = x + 1: cSht = 0 Cells(1, x) = wkBook.Name For Each wkSheet In wkBook.Worksheets cSht = cSht + 1 Cells(cSht + 1, x) = "'" & wkSheet.Name Next wkSheet Next wkBook Dim wkBook As Workbook Dim... Keywords: Charts, Sorting, Fonts, Format, Arrays, Errors, Links, Defined Name, Printing, VBA, Macro, Object, File Name, Files, Hyperlinks, Web, Comments, Validation

 
10. AOL_PROB List of Problems with AOL TOS and Privacy List of problems with AOL Email List of problems with Newsgroups Newsgroups Features added June 1999 Problems with AOL Help Desk and HELP areas Problem with AOL Browser Problem with normal Browsers using AOL 16-bit My System Reply to Marketing Preferences... Keywords: Days, ActiveX, Fonts, Printing, Files, HTML, Internet Explorer, Web, Comments, Window

 
11. IE6 -- Internet Explorer 6.0 *.doubleclick.com *.doubleclick.net *.engage.com *.engageaudience.net *.enliven.com *.enliven.com *.eu-adcenter.net *.eu-adcenter.net *.flycast.com *.focalink.com *.free4all.com *.hitbox.com *.hyperbanner.net *.imgis.com *.link4ads.com *.linkexchange.com *.linksynergy.com *.livestat.com... Keywords: Sorting, Months, Download, ActiveX, Colors, Links, Printing, User Defined Function, VBA, Files, Registry, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
12. Overview of Excel 2002 SP2 Update: October 16, 2002 This update permits the Ask to update automatic links option to override any attempts from a malicious user to suppress the warning dialog that appears in a Microsoft Excel workbook when a Microsoft Excel spreadsheet contains links to external... KB#329750. Keywords: Dates, Download, OLE, Links, PivotTables, Macro, CD-ROM, Files, HTML, Hyperlinks, Web

 
13. Shapes A shape can be assigned a hyperlink, by RClick on shape and assign hyperlink. A shape can be created from a cell, from the Drawing Toolbar, from the Forms Toolbar among what I presume are many other places where shapes can be created. More information on bitmaps in Excel can be found at More on... Keywords: Charts, Colors, Errors, Links, VBA, Macro, Toolbar, Hyperlinks, Web, Comments

 
14. You are prompted to grant permission for ActiveX Controls when you open an Office 2003 document When you open a Microsoft Office Excel 2003 workbook, a Microsoft Office PowerPoint 2003 presentation, a Microsoft Office Word 2003 document, you may be prompted to grant permission for ActiveX Controls to be loaded or to permit the controls... KB#827742. Keywords: ActiveX, VBA, Registry, Links, Web

 
15. How to use the Template Wizard with Data Tracking AddIn in Excel 2000 This step-by-step article describes how to use the Template Wizard with Data Tracking add-in for Microsoft Excel. With the Template Wizard, you can transform a workbook into an online template or form, and link it to a designated database.... KB#214246. Keywords: Add-In, Consolidate, Format, Links, Macro, Files, Templates

 
16. How to Use the Template Wizard with Data Tracking AddIn The Template Wizard with Data Tracking is an add-in for Microsoft Excel. The Template Wizard allows you to transform a workbook into an online template or form, and to link it to a designated database. The Template Wizard walks you through a... KB#148314. Keywords: Add-In, Consolidate, Format, Links, Macro, Files, Templates

 
17. Barhopper -- fixup for Restored Toolbars (also List of Menu Items) There are two macros shown on this page. The Barhopper macro starts of the recursive BarHop macro. The barhopper macro will pick out toolbars containing "Tool" as part of the name and which are not builtin menus, and will call the barhop macro. When running this macro suggest opening up the... Keywords: Add-In, Sorting, Clipboard, VBA, Iteration, Macro, Object, User Defined Function, Files, Toolbar, HTML, Hyperlinks, Web, Comments, Window, INDIRECT

 
18. Administrative Update Available for HTML Script Vulnerability To help you deploy the Excel 2000 and PowerPoint 2000 HTML Script Vulnerability Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting... KB#268654. Keywords: Dates, Download, Setup, Files, HTML, Web

 
19. Administrative Update Available for the Excel 2000 SR1 REGISTER.ID Function Vulnerability To help you deploy the Excel 2000 SR-1 REGISTER.ID Function Vulnerability Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file available... KB#269267. Keywords: Download, Setup, Files, HTML, Web

 
20. Internet Explorer keyboard shortcuts, mouse shortcuts You can use shortcut keys to view and explore Web pages, preview pages before printing, use the Address bar, work with favorites, and edit. Copied from IE Help shortcuts, to be able to use FIND. Click a heading, or press the TAB key to highlight a heading, and then press... Keywords: Download, Fonts, Links, Printing, Clipboard, Files, Toolbar, Internet Explorer, Web, Comments, Window, FIND

 
21. Error Message: An Error Occurred While Loading 'Sheet1111111111111...' In Microsoft Excel 2000, when you try open a file that was saved in Excel 97, you receive an error message similar to the following: An error occurred while loading 'Sheet111111111111111111111111111'. Do you want to continue loading the project?... KB#236299. Keywords: Add-In, Download, Errors, VBA, Macro, Error Message, Links, Web, Window

 
22. Overview of Office XP Clip Organizer Update: June 19th 2002 Microsoft has released an update to Microsoft Office XP Clip Organizer. This update includes several security updates and other fixes. Note This Public Update is part of the Microsoft Office XP Service Pack 2 (SP-2), but for your convenience... KB#324110. Keywords: Dates, Download, CD-ROM, Files, Internet Explorer, Links, Web

 
23. How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer Provides a resolution for an issue that occurs when you click an HTML link to a Microsoft Office file and Internet Explorer opens the file in Internet Explorer instead of opening the file in the appropriate Office... KB#162059. Keywords: Files, Registry, HTML, Internet Explorer, Links, Web, Window

 
24. How to Find Visual Basic for Applications Help This article describes where to find helpful resources to use when you are programming in Microsoft Excel using Microsoft Visual Basic for... KB#142128. Keywords: Object, VBA, Files, Hyperlinks, Web, Window

 
25. Excel 2002 PostService Pack 2 hotfix package: October 6, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated October 6, 2003. back to the top Issues that are fixed in the hotfix package The following issues are fixed... KB#829340. Keywords: Dates, Errors, File Name, Files, Registry, Hyperlinks, Web

 
26. Excel 2002 PostService Pack 2 Hotfix Package: September 25, 2003 This article describes the Microsoft Excel 2002 issue that is fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated September 25, 2003. back to the top Issues that are fixed in the hotfix package The following issue is fixed in... KB#827984. Keywords: Dates, File Name, Files, Registry, Hyperlinks, Internet Explorer, Web, Window

 
27. How to Prevent the Automatic Creation of Hyperlinks When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink: http:// www. ftp:// mailto: file:// news: \\ Excel also creates a hyperlink when you type an e-mail address... KB#291209. Keywords: AutoCorrect, AutoFormat, Errors, Links, Startup, Class, VBA, Macro, Files, Smart Tag, Hyperlinks, Web, Window

 
28. Internet Explorer Prompts User to Open/Save Office File Streamed from ASP When you use an Active Server Pages (ASP) page to stream back the binary contents of an Office file, such as a Microsoft Word document or a Microsoft Excel workbook, you may be prompted to specify whether to open the file directly or save the file... KB#296717. Keywords: Download, Links, Registry, Internet Explorer

 
29. Open Button in Dialog Disabled When You Browse or Redirect to .rtf or .csv Files When you browse to either a Rich Text Format (.rtf) file or to a Comma Separated Value (.csv) file that is located on a Web server, Internet Explorer may prompt you with a File Download dialog box to confirm whether you want to open the file or... KB#318761. Keywords: Download, Format, File Name, Registry, Internet Explorer, Web

 
30. How to Programmatically Save a Worksheet as HTML An updated version of the Internet Assistant Wizard for Microsoft Excel 97 is available. This updated wizard allows you to export a worksheet to a Hypertext Markup Language (HTML) file by using a Visual Basic for Applications macro. NOTE: The... KB#168561. Keywords: Add-In, Charts, Download, Export, Arrays, VBA, Macro, Files, HTML, Web

 
31. How to Add Data to a ComboBox or ListBox in Excel or Word This article describes methods of populating a ComboBox or ListBox... KB#161598. Keywords: Arrays, Combo Box, Macro, Object, UserForm, VBA, Links, Web, Window

 
32. How to Prevent the Automatic Creation of Hyperlinks When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel creates a hyperlink: http:// www. ftp:// mailto: file:// news: \\ Excel also creates a hyperlink when you type an e-mail address in the... KB#233073. Keywords: Errors, Links, Startup, Class, VBA, Macro, Hyperlinks, Web, Window

 
33. How to Use ASP to Build Spreadsheet XML for ClientSide Display This article illustrates Active Server Pages (ASP) script that builds a spreadsheet in the XML Spreadsheet (XMLSS) format by using the Office Spreadsheet component. The XMLSS can be displayed client-side in one of several ways: in the... KB#288130. Keywords: XML, Format, Object, VBA, File Name, Internet Explorer, Web

 
34. Office 2003 cannot run in "Windows 98/Windows Me" compatibility mode When you work in one of the programs that are listed in the Applies to section of this article, you may receive an error message that is similar to the following (where program name is one of the programs that is listed in the Applies to... KB#837130. Keywords: Errors, Error Message, File Name, Files, Links, Web, Window

 
35. Excel 2000 postService Pack 3 hotfix package: February 26, 2004 Describes an issue that occurs if you click a hyperlink on a Web page in Internet Explorer that opens an Excel workbook in Excel 2000 that contains external links, Internet Explorer may appear to stop... KB#837242. Keywords: Dates, Links, File Name, Files, Registry, Hyperlinks, Internet Explorer, Web, Window

 
36. Right Click Menus (Context Menus) in Excel This page contains some VBA macros. If you need assistance to install or to use a macro please refer to my «Getting Started with Macros« or delve into it deeper on my Install page. In my Auto_Open in my personal.xls (I call mine with a different name, you'll have to change code... Keywords: Add-In, Sorting, Errors, Formulas, Links, VBA, Macro, Setup, AutoSave, HTML, Internet Explorer, Web, Comments

 
37. Year 2000 Wizards for Microsoft Excel 97 and 2000 Available for Download Microsoft has developed add-in tools that you can use with Microsoft Excel 97 and Microsoft Excel 2000. These can help you prepare dates in Excel workbooks for transitioning from earlier versions of Excel or for auditing workbooks for the year... KB#176943. Keywords: Add-In, Dates, Years, Download, Format, Links, Macro, Files, Web, Auditing, TODAY

 
38. You cannot change a link path when an Excel AddIn is not loaded When you try to find and to change the link source of a Microsoft Excel Add-In (*.xla) that is referenced by a workbook, and the existing link source contains a long path, you may receive the following error message: Formula is too... KB#817578. Keywords: Add-In, Errors, Formulas, Links, Error Message

 
39. How to Programmatically Disable Microsoft Excel Control Menu Commands You can use the Microsoft Windows Dynamic Link Libraries (DLLs) to disable the commands in the Microsoft Excel Control menu. For example, you can use these tools to delete the Minimize and Maximize... KB#107689. Keywords: VBA, Macro, Menu Command, Links, Web, Window

 
40. Equal Length Cells per Column Name QTY Size Hooded Color Logo Abe 1 S Y Red Team Bob 1 XL N Blue School Chuck 2 L N Blue Team Chuck 2 M Y Red Team Dwain 1 S Y Red Team Evan 1 M N Blue School Frank 2 XXL Y Blue School Fred 2 M Y Red Team George 3 S N Blue School Hal 1 S Y Red Team Harvey 1 XL Y Blue School Jim 2 XXL Y Blue Team... Keywords: Colors, Fonts, Links, PivotTables, VBA, Macro, Web, Comments

 
41. Data Labels Disappear If Value Is Greater Than Axis Maximum When you create a chart in Excel 2002, the chart may not display data labels for each data... KB#811161. Keywords: Charts, Dates, Download, File Name, Files, Registry, Links, Web

 
42. Running Tasks or more directly with Run: msinfo32 then within on the left of System Information: Software Environment, Drivers, Running Tasks... Keywords: Fonts, Startup, Macro, Setup, HTML, Web, Comments

 
43. How to Publish a Web Document to an FTP Site This article describes how to publish a Microsoft Office document to a Web server by using the File Transfer Protocol... KB#237828. Keywords: Download, Microsoft Access, Format, Password, File Name, Files, Links, Web

 
44. How to Return the Source of a Hyperlink in a Cell This article demonstrates how to use Microsoft Visual Basic for Applications (VBA) to programmatically obtain the source address (cell reference) of a... KB#274159. Keywords: Defined Name, VBA, Hyperlinks, Web, Window

 
45. How to Paste New Excel Data into an Existing Graph This article provides sample Visual Basic for Applications (VBA) code that takes a range of cells from a Microsoft Excel 2000 worksheet and pastes the data into a Microsoft Graph 2000 object inside another Microsoft Office 2000 program (in this... KB#267974. Keywords: Charts, SERIES, OLE, Format, Links, VBA, Object, Web

 
46. No Menu Command to Select All Hyperlinks Within a Worksheet Microsoft Excel 2000 has no menu command that lets you select all hyperlinks within a... KB#213790. Keywords: SERIES, Links, VBA, Macro, Object, Menu Command, Hyperlinks, Web

 
47. How to Programmatically Delete Defined Names with Links This article shows you how to create a Microsoft Visual Basic for Applications Sub procedure (macro) that displays all the defined names in the active workbook that have an external reference to a defined name in a different workbook. With the... KB#213385. Keywords: Errors, Links, Defined Name, VBA, Macro, Object, Web

 
48. Rows or Columns Are Missing from a Pasted Microsoft Excel Worksheet If you use the Paste or Paste link command to put a large Microsoft Excel worksheet into a Word document, Word may not include all the columns or rows of the worksheet. Word may cut off the columns and rows that exceed the right or bottom margins... KB#814673. Keywords: Dates, Format, File Name, Files, Links, Web

 
49. How to check and Manage the Status of Links in Excel This step-by-step article describes how to check the status of links and determine what actions are needed based on the status reported. The Edit Links dialog box in Microsoft Excel provides improved functionality, which allows you more control... KB#288940. Keywords: Format, Errors, Links, Object

 
50. How to use the AutoCorrect Options buttons in Excel With the AutoCorrect Hyperlinks button in Microsoft Excel, you can use several options that are related to the process of typing hyperlinks in a cell. Unlike the other recovery options, the AutoCorrect Hyperlinks button always appears below... KB#291357. Keywords: AutoCorrect, AutoFormat, Errors, Smart Tag, Hyperlinks, Web

 

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