|
编程环境是PPT, 希望可以选择PPT里的组合框的值,excel的图表会选择相应的数据源。
路径请根据需要修改 运行到 .SetSourceData Source:=rng 就一直报错 不知道是什么原因,望高手解答。
Private Sub CommandButton1_Click()
Dim xlApp As Object
Dim xlBook As Object
Dim xlSheet As Object
Dim strWbPath As String
Dim xlchart As Object
Dim rng As Object, rng1 As Object
Set xlApp = CreateObject("Excel.Application")
strWbPath = "C:\Users\tang\Desktop\New Folder (3)\Oct HC report new.xls"
Set xlBook = xlApp.Workbooks.Open(strWbPath)
xlApp.Visible = True
Set xlSheet = xlBook.Worksheets("1. HC by Function CRM (2)")
Set rng = xlSheet.Range("A60:N60,A61:N61,A68:N68")
Set rng1 = xlSheet.Range("a60:n60,a62:n62,a69:n69")
Set xlchart = xlSheet.ChartObjects("Chart 7")
Select Case ComboBox1.Value
Case "Product"
With xlchart
.SetSourceData Source:=rng
End With
Case "Division"
With xlchart
.SetSourceData Source:=rng1
End With
End Select
End Sub
本帖最后由 兰色幻想 于 2011-12-1 22:16 编辑
明白了,得指定一下程序才行
With xlchart
.Select
xlApp.ActiveChart.SetSourceData Source:=rng
|
|