Excel OLE object in report

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
 
S

Stephen Lebans

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

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

Top