Excel linking a Table

  • Thread starter Thread starter Amrit
  • Start date Start date
A

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
 
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
 
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
 
Back
Top