| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Source data in a closed Workbook
Hi,
Programmatically, how would i refer to the Chart Source data that is in another Workbook please? Currently i have: ActiveChart.SetSourceData Source:=Workbooks("Cases_Older_Than_One_Year.xls") .Sheets("Charts").Range("A3:" & Mycol & "6"), PlotBy:=xlRows When Cases_Older_Than_One_Year.xls is open it works fine (as i would expect) but i would rather not have to have this WB open at this point in the macro. Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem: Paste Data after Source Workbook in Closed... | Excel Discussion (Misc queries) | |||
| add data to a closed workbook | Excel Programming | |||
| Chart source data when copying from one workbook to another | Excel Programming | |||
| getting data from closed workbook | Excel Programming | |||
| getting data from closed workbook | Excel Programming | |||
Threaded Mode
