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.
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
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...28d8d30c75&dg=microsoft.public.access.reports
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
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...28d8d30c75&dg=microsoft.public.access.reports