I have the next code:

' Save chart as GIF
fname = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
TempChart.Export Filename:=fname, filterName:="GIF"
A.ChartObjects(1).Delete
Application.ScreenUpdating = True


I have a userform in which a have a button which displays a chart, and the
chart is saved temporaly in the same folder as the excel file, but after I
close the file the temp.gif is still there in the folder, so what I want is
to erase the file after is Exported or the excel file is closed. Can this be
done ?

Thanks !

Look at Kill in VBA's help.

But I'm not sure when you'd want to actually delete the file.

Carlos wrote:
>
> I have the next code:
>
> ' Save chart as GIF
> fname = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
> TempChart.Export Filename:=fname, filterName:="GIF"
> A.ChartObjects(1).Delete
> Application.ScreenUpdating = True
>
>
> I have a userform in which a have a button which displays a chart, and the
> chart is saved temporaly in the same folder as the excel file, but after I
> close the file the temp.gif is still there in the folder, so what I want is
> to erase the file after is Exported or the excel file is closed. Can this be
> done ?
>
> Thanks !

--

Dave Peterson

Thanks Dave!

I did use: Kill (ThisWorkbook.Path & Application.PathSeparator & "temp.gif")

Thank you very much!!

"Dave Peterson" wrote:

> Look at Kill in VBA's help.
>
> But I'm not sure when you'd want to actually delete the file.
>
> Carlos wrote:
> >
> > I have the next code:
> >
> > ' Save chart as GIF
> > fname = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
> > TempChart.Export Filename:=fname, filterName:="GIF"
> > A.ChartObjects(1).Delete
> > Application.ScreenUpdating = True
> >
> >
> > I have a userform in which a have a button which displays a chart, and the
> > chart is saved temporaly in the same folder as the excel file, but after I
> > close the file the temp.gif is still there in the folder, so what I want is
> > to erase the file after is Exported or the excel file is closed. Can this be
> > done ?
> >
> > Thanks !
>
> --
>
> Dave Peterson
>