jailout
01-03-2012, 04:19 AM
HI Everybody,
I am working with an excel VBA application, I have an Access file inserted inside a sheet as an OLEObject file. My problem is that I would like to connect to that Access file using DAO or ADO, but I don't know how to do, because I don't know the reference to the OLEObject in order to fill the 'Data Source' field of the connection.
Someone knows what to do?
thanks, :hi:
bye
I am working with an excel VBA application, I have an Access file inserted inside a sheet as an OLEObject file. My problem is that I would like to connect to that Access file using DAO or ADO, but I don't know how to do, because I don't know the reference to the OLEObject in order to fill the 'Data Source' field of the connection.
Someone knows what to do?
thanks, :hi:
bye