Spread 8 ReadMe
Spread 6.0 DAO ActiveX Control to Spread 8.0 Unicode ADO ActiveX Control

If you formerly used the Spread version 6.0 DAO ActiveX control and now want to use the Spread version 8.0 Unicode 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. Upgrade the project files manually using the following steps:
    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\SPREAD60\INCLUDE\SSOCX.BAS
      
      Object={FDAC2480-F4ED-4632-AA78-DCA210A74E49}#6.0#0; SPR32X60.ocx
      
      To:
      C:\Program Files\SPREAD80\INCLUDE\SSOCX.BAS
      
      Object={B9411660-10E6-4A53-BE96-7FED334704FA}#8.0#0; FPSPRU80.ocx
      
      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 = "{FDAC2480-F4ED-4632-AA78-DCA210A74E49}#6.0#0"; "SPR32X60.ocx"
      
      To:
      Object = "{B9411660-10E6-4A53-BE96-7FED334704FA}#8.0#0"; "FPSPRU80.ocx"
      

      For the Spread control change:
      FPSpread.vaSpread
      
      To:
      FPUSpreadADO.fpSpread
      
      For the SpreadPreview control change:
      FPSpread.vaSpreadPreview
      
      To:
      FPUSpreadADO.fpSpreadPreview
      
      When finished, save the files.
  2. 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 as needed.
  3. Save your project and form files and exit Visual Basic.

 

 


Copyright © GrapeCity, inc. All rights reserved.