Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dll error resulting from "CreateWorkspace"
Hi there
I have a MS Excel workbook that contains a VB Macro. The Macro uses Doa/ODBC to retrieve data from a SQL database. Recently, I tried to use this macro on a machine with MSExcel 97 (had previously used later versions). However, I am getting errors all the time from a call to the "CreateWorkspace" function Every time I call it, ther error "Could not load dll: ?????L? - 3633" I have tried unsuccessfully to resolve this be reinstalling and reregistering as number of dlls (eg: MDAC 2.8) - but all to no avail Anyone have any ideas what dll (if any) I shuold be looking for The offending code is like this Dim wsp As Workspac Set wsp = CreateWorkspace("", "admin", "", dbUseODBC) I'd appreciate any help! Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
"Wrap text" makes row larger than text resulting in white space. | Excel Discussion (Misc queries) | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming |