C
curator
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.
I think this is a bug in how the Access report does not read the
'Source
Item' property at all. It merely takes the template of the sheet with
which I
have closed the Excel file with.
The help says that this property can entered from VB or the property
window.
Sajit
Abu Dhabi
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.
I think this is a bug in how the Access report does not read the
'Source
Item' property at all. It merely takes the template of the sheet with
which I
have closed the Excel file with.
The help says that this property can entered from VB or the property
window.
Sajit
Abu Dhabi