Hello,
I was trying to figure out a way to write a direct path to a worksheet in a
workbook, is there a way?
i.e. c:\My Documents\Excel Files\Sales.xls [Jun '08]
Where "Jun '08" is the name of the worksheet in the Sales.xls file. And
maybe if possible even add the name of a graph in that worksheet to the path
file. Like C:\My Documents\Excel Files\Sales.xls [Jun '08] Chart 1
**Chart 1 is the name of the graph in that worksheet.