Evening all,
I can't find the right way to reference an object embedded within a field.
Here's my code:
Dim RS As DAO.Recordset
Dim XL As Object
Set RS = CurrentDb.OpenRecordset("SELECT * FROM [Excel_Workbooks]", dbOpenDynaset, dbSeeChanges)
Set XL = RS![Workbook]
...
I can't see how to fix this... any ideas?
I can't find the right way to reference an object embedded within a field.
Here's my code:
Dim RS As DAO.Recordset
Dim XL As Object
Set RS = CurrentDb.OpenRecordset("SELECT * FROM [Excel_Workbooks]", dbOpenDynaset, dbSeeChanges)
Set XL = RS![Workbook]
...
I can't see how to fix this... any ideas?