Changing the path of an embedded Excel spreadsheet

C

Chris Asaipillai

Hi there

I have a word document with an embedded Excel worksheet.

How am I able to change the path of this worksheet programatically?

I tried using oDoc.InlineShapes(i).OLEFormat but couldnt find
the excel spreadsheet.

Ive linked the spreadsheet using:
'Insert Object' -> Create From Link -> Link to File

Many Thanks

Chris
 
D

Dave Lett

Hi Chris,

If you know which field it is (I notice that you're using "i" as the index
number), then you can use something like the following:
 

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

Embedded Excel into Word with Tables 0
Embed the same Excel multiple times 0
Embedded Excel problem 1
Linking data in MS Word into Excel 5
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Excel embedded in Word and Select range to copy 0
Insert multiple objects at once ? 3
Create timeline with event being hyperlinks to documents on drive 1

Top