If you formerly used the Spread version 3.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. 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={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 = "{B02F3647-766B-11CE-AF28-C3A2FBE76A13}#3.0#0"; "SPR32X30.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.
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.