Excel Graphmacro in Autoit

[GAM]

Hi All,

I'm trying to automate the excel graphs via AutoIt scripts. The task is to create a line graph between two columns of the excel sheet. Can some let me know "how to use this use in the AUTOIT script"?. Or can some one direct me to a link where these kinda examples are stored? Please let me know if any one needs more info from me?

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Range("A:A,B:B").Select

Range("B1").Activate

Charts.Add

ActiveChart.ChartType = xlLineMarkers

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range( _

"A1:B11616"), PlotBy:=xlColumns

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Private Bytes"

With ActiveChart

.HasTitle = True

.ChartTitle.Characters.Text = _

"\\ARJUN2K322\Process(FrameworkService)\Private Bytes"

.Axes(xlCategory, xlPrimary).HasTitle = False

.Axes(xlValue, xlPrimary).HasTitle = False

End With

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[GAM]

Hi All,

I'm trying to automate the excel graphs via AutoIt scripts. The task is to create a line graph between two columns of the excel sheet. Can some let me know "how to use this use in the AUTOIT script"?. Or can some one direct me to a link where these kinda examples are stored? Please let me know if any one needs more info from me?

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Range("A:A,B:B").Select

Range("B1").Activate

Charts.Add

ActiveChart.ChartType = xlLineMarkers

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range( _

"A1:B11616"), PlotBy:=xlColumns

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Private Bytes"

With ActiveChart

.HasTitle = True

.ChartTitle.Characters.Text = _

"\\ARJUN2K322\Process(FrameworkService)\Private Bytes"

.Axes(xlCategory, xlPrimary).HasTitle = False

.Axes(xlValue, xlPrimary).HasTitle = False

End With

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Can someone help me in coding the below code in AutoIT script?

;;;;;;;;;;;;; CODE IN EXCEL MACRO ::::::::::::::::::

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range("A1:B11616"), PlotBy:=xlColumns

;;;;;;;;;;;;; CODE IN EXCEL MACRO ::::::::::::::::::