Download ESQuotes stock quotes in Excel for the Internet
Tools you can use

ESQuotes Micorsoft Excel stock quotes for the Internet
Watch, manage and research your stocks and funds in Excel


Updating your work books

There are a couple of ways to update your workbooks with the latest changes:

If you're upgrading from ESQuotes 1.x or 2.0 to 2.1, you may want to perform these instructions.

Option 1: Copy and paste your spreadsheets into the ESQBlank.xls workbook.

  1. Open your workbook and open ESQBlank
  2. In your workbook, select all the cells in one spreadsheet and press Ctrl+C (Copy).
  3. Goto the new ESQBlank workbook and click on the upper left cell and press Enter
  4. You may have to resize your columns and do some minor formatting.
  5. Save ESQBlank to a new file.

Option 2: Replacing the Visual Basic module in your workbook.

  1. Open the workbook you want to upgrade.
  2. Press Alt+F11 (This brings up the Visual Basic Editor)
  3. Right click on ESQuotes and select Remove ESQuotes
  4. Press Ctrl+M (This is the File:Import menu).
  5. Locate the new ESQuotes.bas module. Press Open.
  6. Double click onThis workbook and copy/paste the text below in the editor window.

    Private Sub Workbook_Open()
    End Sub

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    End Sub

    Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    End Sub

    Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    End Sub

  7. Close the visual basic editor and then save your workbook.

Copyright © 2000-2007 Gilmore Software info@esquotes.com. All rights reserved.

Problem Solved! Gilmore Software Development