Macro to open Folder but not file?

[Zorax]

I have a macro that names and saves a file to a specific folder on a network. This network contains many drives and folders. Every few days the saved files can be deleted but rather than have the user having to search through network drives etc to find the folder, I would like to create a macro that just opens the folder, so that the files can be deleted from there. I have only managed to create a macro that will open a file but not just the folder. Is this possible.

Thanks

 

[litrelord]

Hi,

this would definitely be possible but would need to be done with code written using outlook references. Unfortunately I haven't even begun to look at outlook yet so I can't help. A good start would be to go to the tools menu in your VBE and click references. Scroll down to Microsoft Outlook and put a tick in the box next to it before clicking OK. After doing that you will be able to use all of the objects from the Outlook collection in your excel code. If you use the object browser in the VBE to look for words that may be relevant and hit the F1 key after selecting them it should give you a reasonable example of it's uses. Hopefully you'll be able to get something useful from that.

Good luck