move chart in excel with vb.net

I need to move a chart from one sheet to another in an Excel workbook, and I am having issues with different versions of Windows and Excel.

Here is the code I am currently using:
(excelApp is declared correctly)

excelApp.Workbooks("Book 1").Sheets("Sheet 1").ChartObjects(1).Chart.Location(2, "Chart 2")

This works perfectly and consistently with Windows 7 and Microsoft Office 2007, but fails whenever I try it with Windows XP and Office XP, or Windows XP and Office 2003. I need it to work with the last two setups, so any help would be greatly appreciated.

Thanks,
Jordan

icntoaun

Newbie Poster

1 post since Jul 2010

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months