VBA, refrencing a range

E

Edward

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!R5C2:R7C2

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA,link 0
Need Help with a VBA subroutine 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
find a specific chart in Excel from other applications 0
Exporting data from MS Excel to MS Word VBA 0
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com) 0
Sound repeats unending until closing workbook 2
VBA Question (Again) 2

Top