I am trying to use an Excel file as a template for an Access report. To do this I have linked the excel file through an unbound OLE frame.
The OLE frame is placed over the report detail area and data controls are placed over this at locations such that it fills the template form behind it. The properties of the frame related to the Excel area as, Source Doc : C:\sajit\test.xls Source Item : test1 where test1 is the range name in the Excel sheet. I also have other sheets which are used as templates for other reports. When I preview the report, Access picks the wrong template, even though the filename and the range name specified in frame properties are correct. I have tried giving the reference to the sheet, even though the range name is unique to the Excel file. That does not help either. Sajit
