excel-97

OLEDBConnection.Open() generates 'Unspecified error'

I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object using the .open() method on the object instance and then stores the data in a database. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production...

How do I determine if a range exists, with the Excel 97 SDK [Excel4()]?

I need to know if a range exists, in my Excel addin. I use the Excel97 SDK (the Excel4() function). For instance, I have a range named: NotARealSheet!R1X10 When I set it to an XLOPER, it sets correctly, but when I use it, I get an untrappable error. At least, I can't figure out how to trap it. I would like to know, before I use the ...