Fields Containing Links to Drawings

[ChadDiesel]

I have a table of parts that I would like to add a field for drawings.
These drawings are image files that are on different tabs in an Excel
Workbook--1 image/drawing per worksheet/tab. Most of the Excel workbooks
have 2 tabs. I need to print these drawings in a report. I added an OLE
Object field to my table and selected the location of the file on the
network drive with the "link" option checked:

\sharedrive\Dra wings\drawing1. xls

That works fine on the report. It displays the Excel worksheet/drawing on
the report. However, I need to be able to select a specific worksheet/tab.

By changing the field to a hyperlink, I was able to get this link to work
for the appropriate tab:

\\sharedrive\Dr awings\drawing1 .xls#WORKSHEET1 !A1

However, when I look at this field on the report, it just displays the above
link without showing the Excel sheet.

My question is if there is a way to either set up the OLE Object field to
point to a worksheet/tab or automatically display whatever the hyperlink is
pointing to on the report.
Printing all the worksheets/tabs in the workbook would also work. You might
ask why I want to link to the Excel Sheets. My boss wants to be able to
just drop a new Excel sheet with the same name into a certain folder when a
drawing changes. This is the way we receive the drawings, so I need to do it
this way. Any help would be appreciated.

Thanks,

Chad