Excel chart in desktop

[varcmx1]

Hi, does any one know how can I keep a chart coming from excel file in top of my desktop? Is kind of dashboard, is like a gadget but for excel, I update that chart every date but want to keep it on my desktop


Thanks

 

[Worf]

Welcome to the Forum

' regular module
Public Declare Function SystemParametersInfo Lib "user32" Alias "SystemParametersInfoA" (ByVal uAction&, _
ByVal uParam&, ByVal lpvParam As Any, ByVal fuWinIni&) As Long


Sub NewWallpaper()
Dim p$, ret&
p = "c:\pub\wp2.bmp"         ' where to save image
ActiveChart.Export p        ' save chart as picture
If Err.Number = 0 Then ret = SystemParametersInfo(20, 0&, p, &H2 Or &H1)
End Sub