If you formerly used the Spread version 3.5 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 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:
- 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\SPREAD35\INCLUDE\SSOCX.BAS
Object={F856EC8B-F03C-4515-BDC6-64CBD617566A}#3.5#0; FPSPR35.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}#3.5#0"; "FPSPR35.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 to replace Obsolete Properties.
- Save your project and form files and exit Visual Basic.