View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] khulik13@gmail.com is offline
external usenet poster
 
Posts: 1
Default LoadPicture workaround for Excel 2011 VBA for Mac

Hello, I am having this problem too and am desperately looking for a fix and or workaround for a programming class. This is the applicable part of my code, I'm trying to take a graph that I have plotted on my sheet and upload it as a gif into a picture box on my user form. Any help would be appreciated,

Thanks,

Kevin

'put valujes in sheet
For i = 0 To N
Cells(i + 1, 1) = t(i)
Cells(i + 1, 2) = y(i)
Next

For i = 1 To ActiveSheet.ChartObjects.Count
ActiveSheet.ChartObjects(1).Delete
Next

'create a new chart
ActiveSheet.ChartObjects.Add(300, 100, 500, 300).Select
ActiveChart.ChartType = xlXYScatter

'plot graph
ActiveChart.SetSourceData Source:=ActiveSheet.Range(Cells(1, 1), Cells(N + 1, 2)), PlotBy:=xlColumns
ActiveChart.Legend.Select
Selection.Delete

'load graph to userform
ActiveChart.Export Filename:="/Users/khulik/Desktop tempchart123123.gif", FilterName:="GIF"
solutionimage.Picture = LoadPicture("/Users/khulik/Desktop tempchart123123.gif")


End Sub