Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code fails after upgrading to Office 2007
I'm getting "Can't find project or module" and the word dbUseJet is
highlighted when attempting to run code in a spreadsheet that worked fine with Office 2003. Here is the code Dim wrkJet As DAO.Workspace Dim dbsMktStats As DAO.Database Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet) The code, when it worked, then went on to open a database and run some queries. I have not upgraded the DB to access 2007, but since the failure is on the CreatedWorkspace command, I didn't think it was important (at least, not yet) In Tools...References, I used to have "Microsoft DAO 3.6 Object Library" checked, but someone suggested I uncheck this and check "Microsoft Access 12.0 Access database engine Object Lilbrary", so I tried that, still no good. I also added (again, in "references") "Microsoft Access 12.0 Object Library", but I get the same error every time. Any suggestions would be appreciated. David Jenkins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Move-Drag and Drop Fails in Office 2007 Excel & Word | Excel Discussion (Misc queries) | |||
upgrading to office 2007 | Excel Worksheet Functions | |||
Excel in Office 2007 fails to start ... | Setting up and Configuration of Excel | |||
Excel in office 2007 fails to start.. HELP pls | Setting up and Configuration of Excel | |||
Any problem of migration for upgrading Office 2007 from Office 200 | Excel Discussion (Misc queries) |