Home > Excel Help Portal > Excel and the Web

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

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.

101. Mailto Hyperlink in Office Docs Opens Two New Mail Messages When you click a MailTo hyperlink in a Microsoft Office document, two e-mail message windows... KB#197097. Keywords: Registry, Hyperlinks

 
102. How to Display ASP Results Using Excel in IE with MIME Types Instead of displaying your Web data in HTML tables, you can provide users with the option of displaying the data in Microsoft Excel. This article demonstrates how to create a Web page with tabular data obtained from Microsoft SQL Server, and render... KB#199841. Keywords: SQL, Password, Index Server, HTML, Web

 
103. Error Occurs when you Exit Internet Explorer or Excel When You Use a Pivot Table Control with a Visual Basic User Defined Function If you use a Microsoft Visual Basic User Defined Function in a calculated member, and then the calculated member is used in a Pivot Table control in either Microsoft Excel or Microsoft Internet Explorer, an Application Error may occur when you... KB#291265. Keywords: Download, SQL, Errors, PivotTables, Object, User Defined Function, VBA, Internet Explorer, Web

 
104. Parameter Query Does Not Refresh Automatically When you type a parameter for a Web or database query into a cell, Microsoft Excel does not refresh the query, even though you selected the Refresh automatically when cell value changes check box in the Parameters dialog... KB#236990. Keywords: Query, Formulas, Links, Web

 
105. How to Remove Links from a Worksheet In Microsoft Excel, you can change and move links in the Links dialog box. However, you cannot use the Links dialog box to remove links. This article tells you how to remove links from Excel... KB#214127. Keywords: Formulas, Links, Defined Name

 
106. Use Workbook_Open to open a Userform when a workbook is opened With apologies to Brigitte (question too complicated) and Marie (I never answer questions which are *obviously* typed verbatim from your school homework assignment), the first lucky reader is Judy who asks: "I would like to know how you link dialog box from... Keywords: Sounds, Macro, VBA, Links, Web

 
107. Use Cells(Row, Column) instead of Range() when looping through several columns MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: VBA, Web

 
108. How to create a Link to a Worksheet within an Excel WorkBook in FrontPage 2000 This article describes how to link a web page to a particular worksheet in an Excel workbook.Create a Link to a Specific Worksheet When you create a link to an Excel workbook, it will open to the last worksheet that was viewed. To create a link to... KB#229808. Keywords: Links, Files, Hyperlinks, Web

 
109. MS03050: Vulnerability in Microsoft Word and Microsoft Excel Could Allow Arbitrary Code to Run Microsoft has released security bulletin MS03-050. The security bulletin contains all the relevant information about the security patch, including file manifest information and deployment... KB#831527. Keywords: Web

 
110. Reset Application.ScreenUpdating for forward compatibility with Excel XP MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Macro, VBA, Web

 
111. Outlook Does Not Display a Complete HTML Message or Excel Form If Internet Explorer 6.0 Is Installed Outlook 2000 may not display a complete HTML message or a message that contains an embedded Microsoft Excel form if Microsoft Internet Explorer 6.0 is installed on the computer on which Outlook 2000 is... KB#318256. Keywords: HTML, Internet Explorer

 
112. PivotTable of OLAP Data Does Not Display Data Correctly When you create a PivotTable in the Japanese version of Microsoft Excel, the invalid value 1.7977E+308 is displayed in calculations of Online Analytical Processing (OLAP) cube fields, even if the server returns correct... KB#271900. Keywords: Errors, PivotTables, Internet Explorer, Web

 
113. Frequently Asked Questions About Using Links in Excel 2002 A link in Microsoft Excel can be any of the following: A reference to another workbook (sometimes called an external reference ) A link to another program (sometimes called a remote reference ) A link to data on the Internet, the World Wide Web,... KB#293418. Keywords: Errors, Links, Defined Name, Error Message, HTML, Hyperlinks

 
114. "Cannot Quit EXCEL.EXE" and Can't Log Off from Windows NT If Excel File Open in Internet Explorer If you open a Microsoft Excel workbook as an active document (in-place) within Microsoft Internet Explorer, and then attempt to log off from Windows NT, you cannot log off and Excel returns the following error message: Cannot quit EXCEL.EXE.... KB#235520. Keywords: Errors, Hyperlinks, Internet Explorer

 
115. EUROCONVERT Function Is Lost When You Save Excel Data to a Web Page In Microsoft Excel, when you publish or save your Excel data as a Web page, and the data contains the EUROCONVERT function, only the value of the... KB#235113. Keywords: Web, EUROCONVERT

 
116. Linked Charts Lose Custom Colors When You Update Source Data Linked charts that use custom colors revert to the default colors, when you update the chart data in Microsoft... KB#264517. Keywords: Charts, Colors, Links

 
117. How to Automating Excel From ClientSide VBScript This article illustrates VBScript client-side code that launches and automates Microsoft Excel when a user clicks a button on a Web... KB#198703. Keywords: Charts, Errors, Object, HTML, Web

 
118. Differences in Excel versions I could follow your theory if the situation were reversed. But, anything that you know how to do in Excel 97 should have translated directly to Excel 2000. Microsoft is pretty good about making sure that features from one version work in the next version. The one major exception that I can think of... Keywords: VBA, Web

 
119. Compare Excel Worksheets and Workbooks Keywords: Dates, Links, Files, Toolbar, Web, Comments

 
120. Defined Name No Longer Present When You Open Workbook When you open your workbook, some of the names that you had previously defined are... KB#248165. Keywords: Defined Name, Links, Web

 
121. Frequently Asked Questions About Web Publishing in Excel 2002 You can save a Microsoft Excel 2002 workbook, or part of the workbook (such as a single item on a worksheet), as a Web page and make it available on an HTTP site, an FTP site, a Web server, or a network server for users to view or interact with.... KB#293416. Keywords: Web

 
122. Removing or avoiding automatic hyperlinks You may have discovered that Excel 2000 supports automatic cell hyperlinks. Whenever you type something that resembles a URL or an e-mail address into a cell, this feature automatically converts the text into a clickable hyperlink. But what if you don't want to create a hyperlink? If you use Excel... Keywords: Charts, AutoCorrect, Format, Formulas, Links, Printing, VBA, Macro, Hyperlinks

 
123. Creating Page Breaks in Excel-automaticaly This macro will solve the problem. For some reason, macros that change page breaks or page setups take a long time to run, but this will certainly be faster that doing the process manually. The macro assumes your data is in column A and that it starts in row... Keywords: Macro, VBA, Web

 
124. Quickly Navigate to Any worksheet MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: VBA, Web

 
125. Custom Visio Application Design and Development Downloading Tips 1) Excel 95 Examples Excel 95 examples can be downloaded directly to your hard drive as an "xls" file. If you right click on the link to the example and choose option "Save Target As", then you can specify the folder on your hard disk where you would like the free example to be... Keywords: Download, Password, Files, Links

 
126. Create a unique record number Here is the hypothetical application that I am imagining. There is a workbook with an Invoice worksheet and a Menu worksheet. I propose storing the last invoice number on an out of the way cell on the Menu worksheet, lets say Z1. If the invoice number is supposed to go in cell H2 of the invoice... Keywords: Macro, VBA, Web

 
127. Find the last row of data in a range One common methodLastRow = Cells.SpecialCells(xlCellTypeLastCell).Rowwhich is not very exact, because Excel doesn't keep track of the last cell in a very adequate form.Another method to find the last used row in a particular column is:LastRowColA = Range("A65536").End(xlUp).Rowbut this doesn't tell... Keywords: VBA, Web

 
128. Add Row while copying and manipulating data Here is a macro that will insert a row above the cellpointer and copy the contents of the prior row. Let's assume your data extends from A to T, and that you want to delete the contents of the new row's cells H, K, and MI'll use the keyword ActiveCell to make the macro work in relation to the cell... Keywords: Macro, VBA, Web

 
129. Create and name a new worksheet with VBA Just like this:Dim WS as WorksheetSet WS = Sheets.AddYou don't have to know where is it located, what's it's name, you just refer to it as WS.If you still want to do this the "old fashioned" way, try this:Sheets.Add.Name = "Test" MrExcel.com provides examples of Visual Basic procedures for... Keywords: Macro, VBA, Web

 
130. Eliminating the 'Enable Macros' messagebox in Excel Another possibility is a short VB6 program that would open the Excel file. If you open an Excel file with VB6, you eliminate the enable macros warning. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not... Keywords: Macro, VBA, Web

 
131. How to easily 'unmerge' cells When you have to insert a column and there are some merged cells, DO NOT select the entire column, instead, just select ONE NON-MERGED cell, then go to Edit, Insert, and select "Entire Column". That should work. MrExcel.com provides examples of Visual Basic procedures for illustration only, without... Keywords: VBA, Web

 
132. Add a Certain Number to All Numbers in a Range Using Paste Special Add MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Clipboard, VBA, Web

 
133. Subtotal without grouping For more details and an image about Data Subtotals, read method #4 in Tip 035.-------- MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness... Keywords: VBA, Web

 
134. Paint Job, Coverage Example Keywords: Web, Comments, VLOOKUP, ROUNDUP

 
135. Have an IF statement return "Yes"-"No" Functions can only return a value, they can not modify their "environment". So, the "workaround" for this problem would be to put this formula:=IF(A2=5,"YES","NO")in A3 instead of A1. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed... Keywords: VBA, Web

 
136. Split the contents of one column into two columns To do this, use Text to Columns. Select the column where you have the names, go to Data, Text to Columns, select Delimited in Step 1, in Step 2 make sure that the comma checkbox is activated. Finally, in step 3 select a Destination cell (It defaults to the current cell). Hit Finish and that's it.... Keywords: VBA, Web

 
137. Using the Analysis ToolPack Check the selection for Analysis ToolpackClick OKFrom that point on, XIRR will be available to you. If Analysis Toolpack is not in the list of available Add-Ins, then someone did a custom or minimal install of your Excel. Get the install CD's, do a custom install, and be sure to check the Analysis... Keywords: VBA, Web, XIRR

 
138. Change the worksheet tab name to reflect the value in cell A1 WORKBOOK... Keywords: VBA, Web

 
139. MrExcel's Recommendations: Word help Many times, I have jokingly suggested that a questioner should seek out MrAccess.com or MrWord.com or MrOutlook.com only to lament that no one has taken up that role yet. Well, I am glad to announce that an old friend has taken on the role of offering expertise in MIcrosoft Word. DreamBoat's new... Keywords: VBA, Web

 
140. Using Inputboxes )You can see the Online help for more Types of this Inputbox. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.... Keywords: VBA, Web

 
141. Removing hyperlinks from a worsheet In Excel 2002:Highlight all the cells.Right click, select hyperlink from the pop-up menu.Click the Remove button.In Excel 2000 they did not offer this functionality. You could do it with... Keywords: Links, VBA, Hyperlinks, Web

 
142. Tabbing through specific cells Lock all cells, unlock those cells where the user will enter data and then protect the sheet. That way the use can press TAB to move between unprotected cells.You could also set the EnableSelection property of the sheet to 1 – xlUnlockedCells to prevent the user selecting anything not allowed. This... Keywords: VBA, Web, IS

 
143. Removing hyperlinks from a worsheet In Excel 2002:Highlight all the cells.Right click, select hyperlink from the pop-up menu.Click the Remove button.In Excel 2000 they did not offer this functionality. You could do it with... Keywords: Links, VBA, Hyperlinks, Web

 
144. Use Edit / Replace to Remove Decimal Points MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: VBA, Web

 
145. Recorded Macro to a Usable Macro Keywords: Macro, VBA, Web, Comments

 
146. Working with time formats I always seem to find questions about going the other way. Anyway, if your time is in A1, use this formula:=TEXT(A1,"hhmm") MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied... Keywords: VBA, Web, TEXT

 
147. Maximized view on open Jen asks "How can I make sure Excel opens my file maximized ?, I need this for visibility purposes"To make sure of this, right click in the little workbook (Next to File menu), and choose, View Code.You should see this, and the cursor standing between those... Keywords: VBA, Web

 
148. MrExcel's Recommendations: Access help DreamBoat filled the Word void with TheOfficeExperts.com MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The... Keywords: VBA, Web

 
149. Inserting an image into a worksheet footer Unfortunately, this is only possible "directly" in Excel XP. Before that, you would have to "simulate" a footer by placing the image in a row at the end of each page. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied,... Keywords: VBA, Web

 
150. Creating multiple lines of text in a messagebox Use this code:Msg = "This is line 1" & vbcr & "This is Line 2 " & vbcr & vbcr & "This is Line 4"Msgbox Prompt:=Msg MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of... Keywords: VBA, Web

 

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