Cannot figure out how to find and replace excel links

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

Post Reply
tbryant

Cannot figure out how to find and replace excel links

Post by tbryant » Wed Jun 30, 2004 4:48 am

I have a word document with a number of inline shapes linked to an excel document; i.e. a table that is linked to the excel file c:\BlahBlah\Arizona.xls, coordinates: Table1!R2C1:R19C9 (Table1 being the name of the worksheet within the excel file, found in the grid co-ordinates A2:I19). If I search for the string Table1!R2C1:R19C9, I cannot seem to locate it (in order to ultimately change the co-ordinates).

I am using word 2002. It seems as though I have tried all the possible search locations selected, as well as "inside field codes" selected.

Is what I am seeking to do possible?

User avatar
DataMystic Support
Site Admin
Posts: 2240
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support » Wed Jun 30, 2004 8:27 am

No, it's not possible because the search location is inside an OLE link, not inside any 'normal' kind of field.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests