>>>Thierry
>>>
>>>Thanks - that worked for the client's W7 machine ...... but not for the W8 ! - both running Excel 2010. I will investigate a bit more.... and might be back for more help in due course.
>>>
>>>Thanks for assistance so far.
>>>
>>>Barry
>>>
>>>>what about
>>>>
>>>>COPY TO C:\myfolder\mysheet.XLS TYPE XL5
>>>>
>>
>>FWIW, with COPY TO, you should pretty much always use XL5 rather than XLS. XLS is Excel 2.0 format; many things have changed since then, most importantly, handling of dates and maximum # of rows (and columns, I think).
>>
>>Tamar
>
>Tamar
>Thanks for the pointer. As a related issue - do you know if the ChartWizard method is defunct in Excel2010 - I have encountered a problem with an existing charting application which uses the ChartWizard to get a basic chart in place for me to amend via automation.
>It runs fine against Excel2003 but it now has to run against 2010. I am getting Error message: "OLE IDispatch exception code 0 from S: This object has no title... " and it occurs on the line which calls the ChartWizard.
>
Seems to still be there:
http://office.microsoft.com/en-us/excel-help/create-a-chart-in-a-worksheet-HP005199491.aspxTamar