Refreshing the desktop

[CMIIandExcel]

Hi all

I am having some problems using WIN AIP to refresh the desktop.

Does anyone have any ideas or working code that will refresh the desktop from within vba?

Thanks in advance

Mike

 

[RoryA]

Refresh in what sense?

 

[CMIIandExcel]

Hi Rorya

MY code creates a folder on the desktop and then extracts a number of files from a database and places them in the folder. The folder does not appear on the desktop untill it has been refreshed, manualy done by pressing F5.

Regards

Mike

 

[Jaafar Tribak]

See if this works for you

Private Declare Function InvalidateRect Lib "user32" _
(ByVal hwnd As Long, lpRect As Long, ByVal bErase As Long) As Long

Sub Test()
    InvalidateRect 0, 0, True
End Sub

 

[CMIIandExcel]

Jaafar

Thanks kindly that works, although the desktop is now for some reason refreshing before the code reaches the call

InvalidateRect 0, 0, True

the desktop does however also refresh when it hits the code

Thanks kindly

Mike