Member Avatar for icntoaun
icntoaun 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 133 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.