GAM Posted July 13, 2009 Share Posted July 13, 2009 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 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Neil Link to comment Share on other sites More sharing options...
GAM Posted July 13, 2009 Author Share Posted July 13, 2009 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 :::::::::::::::::: Neil Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now