hey.. im trying to create a chart on a worksheet and then somehow save it and show it as an image on a userform. right now i have

ActiveChart.Export Filename:="C:\Temp\Waterload.gif", FilterName:="GIF"
ufMAIN.imWATERLOAD.Picture = LoadPicture("C:\Temp\Waterload.gif")

this works fine but only if there is a file C:\temp already there. theres got to be an easier and better way to do this... thanks in advance