Excel OLE object in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to print an Excel OLE object in an Access report so it is not
just a snapshot? I have a table with about 15 fields, one of which is an
excel sheet. The report works but the excel field is only a snapshot and
will not grow to encompass all data. The excel sheet may have 3 columns and
4 rows or 12 columns and 35 rows. So, it needs to expand. Or could I get
the Excel field into Excel somehow and print from there?

Any help would be great!
Thanks in advance for any help,
Dave
 
NCD, No Can Do.
There is no workaround. You will have to print the Spreadsheet seperately
from the report(which can be done from within Access).

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top