To need to modify a given project's VBP file to include the Microsoft Excel 8.0 Object Library just for that project.
1. Save and close the project with the Microsoft Excel 5.0 Object Library reference.
2. In a text editor such as NOTEPAD.EXE, open the project's VBP file and change the reference to Microsoft Excel from:
Code:
Reference=*\G{00020813-0000-0000-C000-000000000046}#1.0#9#C:\OFFICE97\_
OFFICE\XL5EN32.OLB#Microsoft Excel 5.0 Object Library
to:
Code:
Reference=*\G{00020813-0000-0000-C000-000000000046}#1.2#0#C:\OFFICE97\_
OFFICE\EXCEL8.OLB#Microsoft Excel 8.0 Object Library
3. Save the project's VBP file and close the text editor.
4. Start Microsoft Visual Basic 4.0x, and then load and save the project.
5. Select Tools, then References. The Microsoft Excel 5.0 Object Library no longer appears in the list. Instead, the Microsoft Excel 8.0 Object Library is available and checked for use with this project. Newly- created projects will revert to the Microsoft Excel 5.0 Object Library.
Bookmarks