[問題] Excel巨集畫圖很慢
軟體: Excel 2007, Win7
硬體: Intel i3-3240T, RAM 8G
我用excel巨集畫大量曲線圖，一開始很快，可是run了大約100個之後就開始變很慢了，
請教各位前輩專家如何解決? 感謝
程式碼如下;
Sub Macro1()
For i = 2 To 1000 Step 2
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range(Cells(1, i), Cells(25, i + 1))
ActiveChart.ChartType = xlLine
ActiveChart.PlotBy = xlColumns
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(i / 2).Chart
mychart.Export Filename:="d:\sales.gif" & Cells(1, i) & ".gif", FilterName:="GIF"
Next
End Sub
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.122.57.34
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1417421683.A.444.html
→
12/01 16:37, , 1F
12/01 16:37, 1F
→
12/01 17:10, , 2F
12/01 17:10, 2F
→
12/01 17:18, , 3F
12/01 17:18, 3F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
