Hi

I've embedded a microsoft office Excel 10 workbook into and access userform. If I want to link it to an external spreadsheet I need to set the OLE Type in the embedded workbooks properties. The problem is it doesn't give me that option. Does it depend on the type of embedded control or can this be linked by using VBA only in these cases?

I'm wondering why this isn't working?

Thanks
Danny2000