ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Database usage within Excel (https://www.excelbanter.com/excel-programming/303569-database-usage-within-excel.html)

David Slicer

Database usage within Excel
 
In Excel 2000, I'm over looking something and not sure what

When I try to define a type as "Database", "Workspace",
(ex: Dim wrkODBC as Workspace) I keep getting the
error "User undefined type".

When I use any database commands (Connection,Open,Query) I
keep getting "sub or function not defined".

Is there a setting or connection that needs to be made to
make these types and functions available to Excel, or is
it a case not all of the modules being loaded at
installation?



All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com