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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Object in MS Access report 3
Exporting records with embedded Word OLE object to Excel 1
Picture from table OLE Object field to report 2
Referencing Excel.Chart.8 OLE Object in Access Report 6
OLE Unbound Object 1
OLE Object 2
Excel linked to report in OLE frame 1
Ole Object Not Printing 1

Back
Top