Spread 3.0 DAO ActiveX Control to Spread 8.0 ADO ActiveX Control

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

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={F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0; fpSPR80.OCXX
```
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 = "{B02F3647-766B-11CE-AF28-C3A2FBE76A13}#3.0#0"; "SPR32X30.OCX"

To:

Object = "{F856EC8B-F03C-4515-BDC6-64CBD617566A}#8.0#0"; "fpSPR80.OCX"

For the Spread control change:

FPSpread.vaSpread

To:

FPSpreadADO.fpSpread

For the SpreadPreview control change:

FPSpread.vaSpreadPreview

To:

FPSpreadADO.fpSpreadPreview

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.