Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2011 for Mac tries to run a file when it starts up | Excel Programming | |||
LoadPicture command for excel 2011 for Mac | Excel Programming | |||
Help Required - 22nd May 2011 | Excel Programming | |||
Dotted Border Quality in Excel:Mac 2011 | Excel Discussion (Misc queries) | |||
Migration to Excel:Mac 2011, but what about the VBA projects? | Excel Programming |