Spread 6.0 ADO ActiveX Control to Spread 8.0 ADO ActiveX Control

If you formerly used the Spread version 6.0 ADO ActiveX control and now want to use the 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.

Open your project in Visual Basic 5 or Visual Basic 6. When prompted to upgrade to use the Spread Spread version 8.0 control, choose Yes. Alternatively, you can upgrade the controls manually, as explained in step 3.
Save the project file and form files and exit Visual Basic.
If you were not prompted to upgrade the controls in step 1 or you chose not to upgrade them, you can do the following:
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={F856EC8B-F03C-4515-BDC6-64CBD617566A}#6.0#0; fpSpr60.ocx
```
  To:
```
C:\Program Files\SPREAD80\INCLUDE\SSOCX.BAS


Object={F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0; fpSPR80.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 = "{F856EC8B-F03C-4515-BDC6-64CBD617566A}#6.0#0"; "fpSpr60.ocx"
```
  To:
```
Object = "{F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0"; "fpSPR80.OCX"
```
  When finished, save the files.
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.
Save your project and form files and exit Visual Basic.