From: CC Chen <dickyhide@...>
Date: 2011-08-08T20:40:21+09:00
Subject: Excel chart question

On Win32ole the excel chart created

I have two columns such as below:

excel.Range("A1").Value = 1
excel.Range("A2").Value = 2
excel.Range("A3").Value = 3

excel.Range("B1").Value = 15
excel.Range("B2").Value = 16
excel.Range("B3").Value = 17

excel.Range("A1:A3").Select();
excelchart1 = workbook.Charts.Add();

excel.Range("B1:B3").Select();
excelchart2 = workbook.Charts.Add();

It will show the error message.
Seems can't use the Select on the same worksheet.

How to create two charts for column A and column B at the same time?

Thanks,

-- 
Posted via http://www.ruby-forum.com/.