About the Macros in Excel 2007

[KK]

Hi All ,

My company just upgrade our microsoft office 2003 to microsoft office 2007 ,
but after that , i used the macro which i write in excel 2003 was doesn't
work , the message "Run time error "3706" ,Provider cannot be found, It may
not be probelly installed ." was display.

When i debug , it was stop there

//open the connection to the project file
Dim conData
Set conData = CreateObject("ADODB.Connection")

conData.ConnectionString =
"Provider=Microsoft.Project.OLEDB.11.0;PROJECT NAME=" & tbFile.Value
conData.ConnectionTimeout = 30
conData.Open //Stop here

Any suggestion ?

I am using Microsoft office 2007 , Microsoft Project 2007 ,Window XP service
pack 3.

 

[jamescox]

Not sure about how you upgraded/migrated everything but you may need to
go into the ODBC configuration section of the Control Panel and redefine
the ODBC configuration for Microsoft Project.

A clue that this might be your problem is that the Office 2007 suite
(at the least the ones I work with) are in folders with "12", not "11"
as part of their names...

Good luck on this!