Spread 8 ReadMe
Spread 3.0 DAO ActiveX Control to Spread 8.0 ADO ActiveX Control

If you formerly used the Spread version 3.0 DAO ActiveX control and now want to use the Spread Spread version 8.0 ADO ActiveX control, complete the following steps with Notepad.exe or a text editor. If your project contains many forms, you might want to consider using a text editor with a search and replace utility.

Note: Back up your project before making any changes.
  1. Edit the project file (.VBP) in a text editor to change the Spread control reference as follows (note that the directories provided are the ones used by the default installation, and they might differ from your installation):

    Change:
    C:\Program Files\SPREAD30\INCLUDE\SSOCX.BAS
    
    Object={B02F3647-766B-11CE-AF28-C3A2FBE76A13}#3.0#0; SPR32X30.OCX
    
    To:
    C:\Program Files\SPREAD80\INCLUDE\SSOCX.BAS
    
    Object={F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0; fpSPR80.OCXX
    
    When finished, save the file.
  2. Edit each form file (.FRM) with a Spread control in a text editor to change the following references:

    Change:
    Object = "{B02F3647-766B-11CE-AF28-C3A2FBE76A13}#3.0#0"; "SPR32X30.OCX"
    
    To:
    Object = "{F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0"; "fpSPR80.OCX"
    

    For the Spread control change:
    FPSpread.vaSpread
    
    To:
    FPSpreadADO.fpSpread
    
    For the SpreadPreview control change:
    FPSpread.vaSpreadPreview
    
    To:
    FPSpreadADO.fpSpreadPreview
    
    When finished, save the files.
  3. Open your project in Visual Basic 5 or Visual Basic 6 and verify that the project uses the updated files.Review the changes in Changes to Spread ActiveX Components and update your project to replace Obsolete Properties.
  4. Save your project and form files and exit Visual Basic.

 

 


Copyright © GrapeCity, inc. All rights reserved.