VB6 Database using Excel 9.0

set db = OpenDatabase(Filepath, False, False, "Excel 8.0; HDR=yes;")
works to create a database for an excel 8.0 spreadsheet.

We have upgraded to Excel 9.0
I tried to change to Excel 9.0 in my programs and the code gives me an error.

What is causing the error?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories