Posted to microsoft.public.excel.programming
|
|
error displayed on rs.open when using late binding
Thanks for the help ron,
Do you know where I could find this number associations? and how to use them
here?
Thanks in advance
"Ron de Bruin" wrote:
Hi Sam
You must use the number for
adOpenKeyset
adLockOptimistic
....................
Set a reference to activex data objects and enter this in the Immediate window in the VBA editor
? adOpenKeyset
After you press enter you see the number
Maybe this page will help
http://www.rondebruin.nl/ado.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"sam" wrote in message ...
Hi All,
I am getting an error on this line, when I used late binding.
rs.Open "Sheet1", cn, adOpenKeyset, adLockOptimistic, adCmdTable
Am I missing something or doing something wrong? I am using ADO to connect.
Thanks in advance
|