S
Sajit
I am trying to use an Excel file as a template for an Access report. Linked
the excel file through OLE frame with the properties set as follows:
Source Doc : C:\sajit\test.xls
Source Item : test1
where test1 is the range name in which the template is.
I also have other sheets which are used as templates for other reports. The
templates were made by making a 'Copy' 'Sheet' from the previous sheet, each
sheet contains one template range.
When I preview the report, Access picks the wrong template, even though the
filename and the range name specified in properties are correct. Excel seems
to have a problem with defining range names, please see the post titled
'range naming problems' under Excel Application errors.
the excel file through OLE frame with the properties set as follows:
Source Doc : C:\sajit\test.xls
Source Item : test1
where test1 is the range name in which the template is.
I also have other sheets which are used as templates for other reports. The
templates were made by making a 'Copy' 'Sheet' from the previous sheet, each
sheet contains one template range.
When I preview the report, Access picks the wrong template, even though the
filename and the range name specified in properties are correct. Excel seems
to have a problem with defining range names, please see the post titled
'range naming problems' under Excel Application errors.