Excel linking a Table

[Amrit]

Opening the linked table source:
- how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2"

Updating the Source file name of a linked table in Powerpoint:
- how do i get the full path of the file?

thanks,
Amrit

 

[Amrit]

Hi Steve,

Apologies for not providing enough information.

1) when linking an excel table, ie Copy cells in Excel and Paste Special,
Paste link, Microsoft Office Excel Worksheet Object:
The path of the linked table appears as :
C:\Documents and Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2

I want to be able to Open the Source file and Select the cells. How do I do
this programmatically?

2) I want to be able to change the Source File of the linked table
(including selected cells) in the oSh.LinkFormat.SourceFullName.

e.g.
Current SourceFullName : C:\Documents and
Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2

New filename: C:\Documents and Settings\aparmar\Desktop\Book2.xslx

I want the following, ie selecting the same cells as the original:
Updated Source : C:\Documents and
Settings\aparmar\Desktop\Book2.xslx!Sheet!R1C1:R5C2

Regards,
Amrit

 

[Amrit]

1) how do i open an excel file, using the Linkformat.SourceFullName as:
C:\Documents and Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2

- currently I'm stripping off the extra references (!Sheet!R1C1:R5C2), so I
can use (C:\Documents and Settings\aparmar\Desktop\Book1.xslx) to open in
Excel. I'm stripping it using a Split by String method with ".xslx!" being
the item I split against - so thought there must be a better way.

- now "!Sheet!R1C1:R5C2" shows the sheet and Row / Column reference of the
cells selected. Upon opening the Excel, is there a way to select the correct
Tab and Cells? Except for parsing "!Sheet!R1C1:R5C2" to extract the Sheet and
Cell references, is there another way?

2) Yes, I'm using Replace function, i thought there might be a better way.

thanks,
Amrit