VBA, refrencing a range
 

Hi everyone,
I have the path to a chart or a range in Excel ( using link obk=jects
sourcefullname)
C:\WINDOWS\Standard\Desktop\Book10.xlsx!Sheet1![Book10.xlsx]Sheet1 myChart
or for a range
C:\WINDOWS\Standard\Desktop\Book10.xlsx!Sheet1!R5C 2:R7C2

how can I refrence these in Excel VBA ?
I mean I want to open these files and copy the specififc chart or range ?
--
Best regards,
Edward