If you formerly used the Spread version 7.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.
![](images/hs-note.gif) |
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 7.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:
- 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):
C:\Program Files\SPREAD70\INCLUDE\SSOCX.BAS
Object={F856EC8B-F03C-4515-BDC6-64CBD617566A}#7.0#0; fpSPR70.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.
- 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}#7.0#0"; "fpSPR70.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.