VBA problem using RDO on WinXP or 2000 with Excel97 
Author Message
 VBA problem using RDO on WinXP or 2000 with Excel97

I get the error Activex Can't create object when using RDO
from Excel 97 on WindowsXP.

The error shows when first calling any method of the RDO
object.

-I've already un-referenced and re-referenced the
MSRDO20.DLL.
-If Visual Studio is installed, the problem is resolved
but, because of a licensing problem, that solution is not
available to us.
-We've also ran the Mdac_typ.exe created using a project
that connects throw RDO. But the problem from VBA persists.
-If an VB application that uses RDO is installed, it works
perfect!. But, without un-installing it, our Excel fails.
-This same problem happend when using win2000.
-The Excel app. runing on Win95 works just fine.

Any one know if there is any incompatibility problem with
RDO, VBA and WinXP or Win2000???

Any suggestions will be appreciated.
Thanks,

Cecilia



Tue, 29 Nov 2005 22:20:29 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. vba excel97/2000 - getsaveasfilename

2. Simple Excel97-2000 VBA macro fails in Excel 2002

3. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

4. Print formatting problems -- Using VBA in Access 2000 to print a doc in Word

5. Problem in vb using vba Commands for Word 2000

6. Problems pasting pictures in Word 2000 (using VBA)

7. Need Help Manipulating Excel 2000 from Access 2000 using VBA

8. Excel97 VBA Problem

9. VB5 - rdo - Client/server(DCOM) application problem with 2000/xp

10. File Open/Save dialog in Access 2000 running on Win98, Win2K and WinXP

11. Porting Excel 2000 Toolbars in Win98 to Excel 2002 in WinXP

12. ADO & RDO with WinXP

 

 
Powered by phpBB® Forum Software