greetings..
i'm suppose to make a programme that reads a notepad file generated by other programme interfacing with an device which tests components, and then generates a graph of it in Excel.. so far i've succeeded in reading from the notepad file and making a spreadsheet in excel, but not able to generate a chart in any way.. the most i get to is to generate the box where the chart is to be in..
i used some of the examples found (googled them out) but none of them works
these are some of the declarations i made
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSht As Excel.Worksheet
Dim xlRng As Excel.Range
Dim xlChart As Excel.Chart
Dim GeneratedChart As Excel.ChartObject
and here's the part that i use to generate my chart
Set GeneratedChart = ActiveSheet.ChartObjects.Add _
(Left:=100, Width:=375, Top:=300, Height:=225)
GeneratedChart.Chart.SetSourceData Source:=Sheets("Sheet1").Range("K3:K41")
GeneratedChart.Chart.ChartType = xlXYScatterLines
End Sub
i also tried using recorded macro in excel when generating a chart, and copy paste it into my code but that doesnt work either..
i'd be glad if someone can help me out in this part..thanks in advance
-osman-
