View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edward edward is offline
external usenet poster
 
Posts: 87
Default 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