By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Fields Containing Links to Drawings

P: n/a
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\Drawings\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\Drawings\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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.