Search results
-
K
Linking to .accdb from Excel
The following is a VBA module in an Excel 2007 spreadsheet. It works fine when the database is ".mdb" (Access 2003) but not when it's ".accdb" (Access 2007). I tried the simple thing of changing the ofn.lpstrFilter line to .accdb vice .mdb but that didn't work, other than to make the .accdb file... -
K
VBA Module in Excel Spreadsheet pulling info from Access Database
The following is a VBA module in an Excel spreadsheet. It works fine when the database is ".mdb" but not when it's ".accdb". I tried the simple thing of changing the ofn.lpstrFilter line to .accdb vice .mdb but that didn't work, other than to make the .accdb file visible in the open file window...- kesmith
- Thread
- Replies: 0
- Forum: Modules & VBA