Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About the Macros in Excel 2007
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
About the Macros in Excel 2007
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! -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=114427 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macros in 2007 | Excel Discussion (Misc queries) | |||
help with macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) |