Excel linking a Table

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

"Steve Rindsberg" wrote:

> In article wrote:
> > Opening the linked table source:
> > - how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2"
>
> What exactly do you want to remove, and from what?
>
> > Updating the Source file name of a linked table in Powerpoint:
> > - how do i get the full path of the file?
>
> assuming a reference to the shape in oSh:
>
> With oSh
> Debug.Print .LinkFormat.SourceFullName
> End With
>
> ==============================
> PPT Frequently Asked Questions
> [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
>
> PPTools add-ins for PowerPoint
> [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
>
>
 >> Stay informed about: Excel linking a Table 

In article wrote:
> > > Opening the linked table source:
> > > - how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2"
> >
> > What exactly do you want to remove, and from what?
> >
> > > Updating the Source file name of a linked table in Powerpoint:
> > > - how do i get the full path of the file?
> >
> > assuming a reference to the shape in oSh:
> >
> > With oSh
> > Debug.Print .LinkFormat.SourceFullName
> > End With
> >
> > ==============================
> > PPT Frequently Asked Questions
> > [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
> >
> > PPTools add-ins for PowerPoint
> > [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
> >
> >


==============================
PPT Frequently Asked Questions
[URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]

PPTools add-ins for PowerPoint
[URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
 >> Stay informed about: Excel linking a Table 

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

"Steve Rindsberg" wrote:

> In article wrote:
> > > > Opening the linked table source:
> > > > - how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2"
> > >
> > > What exactly do you want to remove, and from what?
> > >
> > > > Updating the Source file name of a linked table in Powerpoint:
> > > > - how do i get the full path of the file?
> > >
> > > assuming a reference to the shape in oSh:
> > >
> > > With oSh
> > > Debug.Print .LinkFormat.SourceFullName
> > > End With
> > >
> > > ==============================
> > > PPT Frequently Asked Questions
> > > [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
> > >
> > > PPTools add-ins for PowerPoint
> > > [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
> > >
> > >
>
>
> ==============================
> PPT Frequently Asked Questions
> [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
>
> PPTools add-ins for PowerPoint
> [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
>
>
 >> Stay informed about: Excel linking a Table 

In article wrote:
> > > > > Opening the linked table source:
> > > > > - how do I remove the extra link info (e.g. "Book1.xslx!Sheet!R1C1:R5C2"
> > > >
> > > > What exactly do you want to remove, and from what?
> > > >
> > > > > Updating the Source file name of a linked table in Powerpoint:
> > > > > - how do i get the full path of the file?
> > > >
> > > > assuming a reference to the shape in oSh:
> > > >
> > > > With oSh
> > > > Debug.Print .LinkFormat.SourceFullName
> > > > End With
> > > >
> > > > ==============================
> > > > PPT Frequently Asked Questions
> > > > [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
> > > >
> > > > PPTools add-ins for PowerPoint
> > > > [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
> > > >
> > > >
> >
> >
> > ==============================
> > PPT Frequently Asked Questions
> > [URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]
> >
> > PPTools add-ins for PowerPoint
> > [URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
> >
> >


==============================
PPT Frequently Asked Questions
[URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]

PPTools add-ins for PowerPoint
[URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]
 >> Stay informed about: Excel linking a Table