The following macro does the following for all the items in a Folder
Opens the Item.
Waits a short while
and then Closes the item.
(I use this to speed up the updating of my google desktop database whenI move my stuff from the server to loca user files)
The problem that I have right now is that I changed the behavior of Journal Items to open the actual Document instead of the journal item itself when clicking on them and when I run my macro it tries to open thousands of documents.
My question is how can I handl this in my macro?
I can either
change this behaviour at the begining of my macro
run the macro
and change this setting back to the way I need it at the end
OR check if it is a journal item and if so skip it
I need help on implementing either of these two solutions (preferrably the first) or any other idea that will handle my requirements.
On Error GoTo OpenAndCloseThemAll_Error
MsgBox "All Done!", vbInformation + vbOKOnly, "Open And Close Them All Macro"
On Error GoTo 0